Selecting a range

  • Thread starter Thread starter Gary
  • Start date Start date
G

Gary

Is there a way to do this: Range("C2:E2").Select

but use non-lettered coordinates? I don't want to use C2, I want to use
(2,3) for row and cell coordinates or something like that. I'm trying to
repeat the block of formatting and don't want to calculate what letter I
should be on.

Thanks for your help.

Gary
 
Gary,

Yes, it is

Range(Cells(2,3),Cells(2,5)).Select

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Gary,

Range(Cells(2, 3), Cells(2, 5)).Select

(General : Range(Cells(row,column), Cells(Row2,column2)).Select )

--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *
 
Back
Top