Macros and Print Areas

[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?

 

[Thomas A. Rowe]

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.
==============================================

 

[Rob Giordano \(Crash\)]

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?

 

[Andrew Murray]

Try the EXCEL newgroup.