View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Michael Michael is offline
external usenet poster
 
Posts: 791
Default multiple cell reference

Range(Cells(2, 1), Cells(10, 5)).Select

--
If this posting was helpful, please click on the Yes button.
Regards,

Michael Arch.




"catrrmg" wrote:

hi all
someone pls help me: how do I select the following range, using row, column:
2,1 x 10,5 in excel vba.
your help will be much appreciated.