Macros and Print Areas

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a macro that I run against hundreds of different files. Each file has
8 columns however, the rows vary between 5 and 175. Just before the macro
stops, I want it to set the print area around only the active cells (rows
with data). What are the Excel keystrokes needed to build the new code for
my macro?
 
You need to post this to the Excel newsgroup

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================
 
You should post this one in the Excel newsgroup(s).



|I have a macro that I run against hundreds of different files. Each file
has
| 8 columns however, the rows vary between 5 and 175. Just before the
macro
| stops, I want it to set the print area around only the active cells (rows
| with data). What are the Excel keystrokes needed to build the new code
for
| my macro?
 
Back
Top