Selecting a Range

  • Thread starter Thread starter KulbirSingh
  • Start date Start date
K

KulbirSingh

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
 
hi
the line you may be looking for is
Range("A1",Range("A1").end(xldown).Offset(0,10))
this will select a range starting at a1 down to the
lastrow of data(assumming there are no blanks) and over 10
columns(J).
Another way
cells(1,1).select
Selection.CurrentRegion.Select
Regards
Frank
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can Vba workout if a selection is part of a group? 0
Print Area Range Selection 2
Macro Related to Paste Values 2
VBA set thick borders around non empty cells in range 0
Setting a variable print area 4
How do you select a row 1
Excel VBA - Problem with Closing Print Preview 0
Insert Page Break Based on Text 5

Back
Top