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.
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.
Last edited by Traymond; 04-27-2009 at 04:44 PM.
Traymond,
Please use a more descriptive title next time. Does this help
VBA NoobPlease Login or Register to view this content.
_________________________________________
Credo Elvem ipsum etian vivere
_________________________________________
A message for cross posters
Please remember to wrap code.
Forum Rules
Please add to your signature if you found this link helpful. Excel links !!!
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
Never Mind i answered my own question. just did not think before i opened my mouth. Problem Solved..... Thanks so much
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks