View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Woodi2 Woodi2 is offline
external usenet poster
 
Posts: 61
Default 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