Range formula with variable

[rizmomin]

Hello:

I have
M = Range("M1").Value
R = Range("M2").Value
M3 = 56
M4 = 57

I need to create formula by using above formula : X = Range(M56:R67).

Something like : X = Range("M"&M3:"R"&M4)

Basically want to select the Range M56:R67 to be copied/

Please let me know if you have any questions.
Thanks.

RM

[Madhut]

try this.. should work..

Range("M" & M3 & ":R" & M4).select - this line is to select

Range("M"&M3 & ":R" & M4).copy - this line is to copy

[rizmomin]

Hi Madhut:

Works ....Thanks a lot
Riz

[Madhut]

Hi Madhut:

Works ....Thanks a lot
Riz

Glad that this works for you.

It would be great, if you could click on "Add Reputation" on my post.