how to use a macro to print column A cells that hold a value more than (0)

[harry h]

Hello I wonder if it can be done.
I have a sheet that has inputs from another sheet that are placed into column A only and the inputs are four or six digits in length.
I need to press a button on the sheet that will print all the cells in column A that have a value in them only and stop printing when it comes to a cell with a zero value.

The sheet is updated daily with the four or six digits added to to the next available cell in column A.
The sheet is auto saved on closing to keep the data safe.

Thank you for reading my thread.

harry h

(One day all must know of the true God.)

[nathansav]

Please Login or Register  to view this content.

[harry h]

I run this Macro, but it brings up:

Compile error:
Can't find project or library

Any advise?

harry h.

(one day all will know the true God)

[JOHN H. DAVIS]

Maybe?:

Please Login or Register  to view this content.

[nathansav]

Sorry, printout, not print.

[harry h]

That is just what I needed thanks John. H. D.
It works a treat. What would I do without this Forum?

harry h.

(All will one day know his name who is Jehovah)

[harry h]

Thanks to you Nathansav.

yours works now as well.

harry h.

[JOHN H. DAVIS]

You're welcome. Glad you've got some solutions. Please comply with Forum Rule No. 9.


9. Acknowledge the responses you receive, good or bad. If your problem is solved, please say so clearly, and mark your thread as Solved: Click Thread Tools above your first post, select "Mark your thread as Solved". Or click the Edit button on your first post in the thread, Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Dropdown option or Edit button will not appear -- ask a moderator to mark it.