Quick Help with Editing Range

VBANate · May 22, 2015

Hello VBAers,

Could you please tell me how I can change the highlighted part of the code to only copy cells between rows A20:A100 and Column IV?

Much Appreciated,

Nathan

Momentman · May 22, 2015

Do yoy mean something like this

Code:

Range("A20:IV100").Copy

VBANate · May 23, 2015

Momentman said:
Do yoy mean something like this

Code:

Range("A20:IV100").Copy

I believe so. I can not test this at the moment, but will do so on Tuesday. Thanks for your help!

VBANate · May 26, 2015

Momentman said:
Do yoy mean something like this

Code:

Range("A20:IV100").Copy

That worked well, thank you.