View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
KimberlyC KimberlyC is offline
external usenet poster
 
Posts: 124
Default Setting print area with vba

Hi !

I would like to run vba code (to execute from a command button) that would
determine the last entry in column A of the acitve worksheet and then set
the print area of the active worksheet to that last row (entry) in column
A..and stop at col J going across.
The last column I would ever want to include in the print area is column
J...The rows could go on and on...or stop at 20.

For Example ... if the last entry in column A is cell A320, then the print
area would be A1:J320
(col J would always be the stop point for going across).

Thanks in advance for your help!
Kimberly