Please could somebody help me.
I need to set the print area in a macro. The range that I want to set the print area to is returned to a cell.
For example:
Cell B5 contains the value: $B$1:$O$50.
In the macro I have the line: ActiveSheet.PageSetup.PrintArea = ???
What do I put in place of the ??? above, to retrieve the value from B5?
Thank you!
TIM[/b]
I need to set the print area in a macro. The range that I want to set the print area to is returned to a cell.
For example:
Cell B5 contains the value: $B$1:$O$50.
In the macro I have the line: ActiveSheet.PageSetup.PrintArea = ???
What do I put in place of the ??? above, to retrieve the value from B5?
Thank you!
TIM[/b]