I am running the following macro which sets the print area to only include rows where there is data in column A. However, I only want to print rows where there is an actual VALUE (ie, not just a formula which creates a null value).
Any ideas would be greatly appreciated!
Please Login or Register to view this content.
Replace this...
With this...Please Login or Register to view this content.
Please Login or Register to view this content.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
Works perfectly. Thanks again!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks