How to use Range property inside for loop as below?

[dmadhup]

Hi,

I am trying to copy the range of cells inside for loop. My intention to copy Range("N" & i to "U" & i)

For this, I have written below code but the compiler is not happy with it. Any help, please.

For i = 6 to 100
Range("N" & i : "U" & i).Copy
Next i

 

[Michael M]

Use

Range("N" & i & ":U" & i).Copy

 

[dmadhup]

Thank you, Michael.