selecting multiple cells in VBA
 

I am using code on a userform and part of the code finds the last cell used
in row V then selects the cell 9 cells to the left, on this occasion row M,
as follows
Range("v7").Select
Range("V7").End(xlDown).Select
ActiveCell.Offset(0, -9).Select

How I can select the 5 cells to the right and 3 cells down at the same time.
i.e., my code would select cell M3, i then want to highlight M3 to R5. From
there i need to add borders around these cells but I think I can manage that
bit.
Thanks
Ian

selecting multiple cells in VBA
 

On Fri, 28 Aug 2009 21:30:01 -0700, Woodi2
wrote:

I am using code on a userform and part of the code finds the last cell used
in row V then selects the cell 9 cells to the left, on this occasion row M,
as follows
Range("v7").Select
Range("V7").End(xlDown).Select
ActiveCell.Offset(0, -9).Select

How I can select the 5 cells to the right and 3 cells down at the same time.
i.e., my code would select cell M3, i then want to highlight M3 to R5. From
there i need to add borders around these cells but I think I can manage that
bit.
Thanks
Ian


Try this modification to your last statement

ActiveCell.Offset(0, -9).Resize(3, 6).Select

Hope this helps / Lars-Åke

selecting multiple cells in VBA
 

Something like this?

Range("M3:R5").Select

And then apply your border code.

Try this for your V7 offset selection, it's a bit shorter.

Range("V7").End(xlDown).Offset(0, -9).Select

HTH
Regards,
Howard

"Woodi2" wrote in message
...
I am using code on a userform and part of the code finds the last cell used
in row V then selects the cell 9 cells to the left, on this occasion row
M,
as follows
Range("v7").Select
Range("V7").End(xlDown).Select
ActiveCell.Offset(0, -9).Select

How I can select the 5 cells to the right and 3 cells down at the same
time.
i.e., my code would select cell M3, i then want to highlight M3 to R5.
From
there i need to add borders around these cells but I think I can manage
that
bit.
Thanks
Ian