Selection of multiple ranges

[Nipendra.dhiman]

Hi All,

i need to select and copy different ranges in excel but i am stuck please suggest.
j=2

i am using below:-
Range("T" & j & ":AA" & j, "AM" & j).Select

giving wrong selection

selecting T to AM

Thanks
Nipen

 

[Nipendra.dhiman]

Please rply little urgnt

 

[KenU]

It appears that your statement needs some modification as below:

Range("T" & j & ":AA" & j & ", AM" & j).Select

Hope that helps.

Regards,
Ken

 

[Nipendra.dhiman]

Thank u for the response
i have tried it and getting the error method range failed

 

[NARAYANK991]

Hi ,

Instead of posting one line of code , and expecting an answer , you can do one of 2 things :

1. Post a complete , detailed description of what you want done

2. Post your complete code

Narayan

 

[Nipendra.dhiman]

Got the solution thank you Guys