I want to write up a macro to set print area of my sheets in a file
Here is the process I use:
I select B11
I do shift + down arrow
I continue holding shift and go to Column J
I set up this range to be print-area range.
when I record the macro, it gives me absolute range for print area an
as such I can't use this macro for other sheets where the print are
could be different.
How do you write "Shift + up arrow" in VBA.
Sorry for the stupid question but I am just a newbie in programming an
need your help.
Thanks,
Kulbir Sing
--
KulbirSing
-----------------------------------------------------------------------
KulbirSingh's Profile:
http://www.excelforum.com/member.php...fo&userid=1562
View this thread:
http://www.excelforum.com/showthread.php?threadid=27277