Range with numerical data

[Guest]

What would be the correct code for the following range :

Range A1224

count1= 12
count2=24

I am writing the following , but it does not work :
Range ( "A & count1 : D" & count2).Select

Thanks,

Moises

 

[Ron de Bruin]

Use this

Range("A" & count1 & "" & count2).Select

 

[Bob Phillips]

Almost there!

Range ( "A & count1 & ": D" & count2).Select


--

HTH

RP
(remove nothere from the email address if mailing direct)