Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to select the print area
I have a table to which the print area may change
significantly, and wish to write a macro to defines the print area. I have a cell in the spreadsheet, $A$1, whos text defines the print area (this is done using the CELL("address", ) worksheet function). On the page setup sheet, I can type into the print area box =INDIRECT($A$1) and the print area is set correctly. I wish to write a macro that enters =INDIRECT($A$1) as the print area. Visual Basic does not recognize the INDIRECT formula from Excell. Does anyone know how to do this? Or know another way to write a macro to define the print area without having to enter the cell range? Regards, Gav |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can Excel automatically select print area on non-blank cells? | Excel Discussion (Misc queries) | |||
setting the print area from a macro | Excel Worksheet Functions | |||
How to end/up end/across to select print area? | Excel Discussion (Misc queries) | |||
Pivot Table macro to set print area and print details of drill down data | Excel Discussion (Misc queries) | |||
Create a print macro that would automatically select print area? | Excel Worksheet Functions |