Trying to create a macro to format a sheet to fit on 1 to 2 pages (this varies) and present itself in the print preview ready for printing. The file I'm using this macro for recieves updates via a link which adds a new data entry to the bottom row each time it gets updated (that is of course if there are any new entries) I need a line of code which will tell it to print only the data entries (plus new ones) and leave out blank lines.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
VBa Printing Problems
- Thread starter futbuk
- Start date
- Status
Similar threads
- Locked
- Question
- Locked
- Question