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