Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Print Area Setting | Excel Discussion (Misc queries) | |||
Setting print area | Excel Discussion (Misc queries) | |||
setting print area via VBA | Excel Programming | |||
SETTING PRINT AREA IN VBA | Excel Programming | |||
Setting print area | Excel Programming |