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