Range with numerical data

What would be the correct code for the following range :

Range A12:D24

count1= 12
count2=24

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

Thanks,

Moises

Use this

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



--
Regards Ron de Bruin
http://www.rondebruin.nl


"Moises" <[email protected]> wrote in message news:[email protected]...
>
> What would be the correct code for the following range :
>
> Range A12:D24
>
> count1= 12
> count2=24
>
> I am writing the following , but it does not work :
> Range ( "A & count1 : D" & count2).Select
>
> Thanks,
>
> Moises

Almost there!

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


--

HTH

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


"Moises" <[email protected]> wrote in message
news:[email protected]...
>
> What would be the correct code for the following range :
>
> Range A12:D24
>
> count1= 12
> count2=24
>
> I am writing the following , but it does not work :
> Range ( "A & count1 : D" & count2).Select
>
> Thanks,
>
> Moises