Thread: Adding new rows to spreadsheet
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
  
Posts: 27,285
Default Adding new rows to spreadsheet
Range("A1").CurrentRegion.Printout

--
Regards,
Tom Ogilvy

"Roy" wrote in message
...
Here's a scenario:

I have a macro that prints the range a1:c52. I then add
a few rows within this range. How do I get the macro to
adjust the print range to include the new range?


Reply With QuoteReply With Quote