Selecting a range

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
 
B

Bob Phillips

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)
 
A

A.W.J. Ales

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 *
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pasting a cell into bookmarked table from excel vba 1
Copying formulas across columns 2
Merging from an Excel file with graphics 1
Copy addition formula of non-consecutive horizontal cells 2
Need Help with a VBA subroutine 0
Using IF and VLOOKUP for range of cells 5
Formatting a spreadsheet to calculate difference in dates etc. 2
Modern equivalent of Autotext in Word? 0

Top