Printing Code - print everything down the sheet until it sees a blank in col A

[Traymond]

I want to have code that will print everything down the sheet until it sees a blank in column A. I have included the code i am trying but it keeps giving me errors. Thanks for your time

Please Login or Register  to view this content.

[VBA Noob]

Traymond,

Please use a more descriptive title next time. Does this help

Please Login or Register  to view this content.

VBA Noob

[Traymond]

That works great !!!! but i have another issue i was not thinking would effect this. It counts a cell with a function in it as not blank. i thought as long as data was not showing in the cell it would be considered blank. I have to have this function in column A . Do you know another way to do this. i am trying to keep it from printing empy pages . I only want it to print down to where it finds data then stops. since my data varies so much i can't set a firm page break. Thanks

[Traymond]

Never Mind i answered my own question. just did not think before i opened my mouth. Problem Solved..... Thanks so much