Column name defined, want to call by that name in code

[VBABEGINER]

I have quick question..

Hi All,
I have define name to entire column. Now while doing code, I want to write in a code like this..

instead of

wk1.Range("G1:G" & LR).Copy

I want it like this..

wk1.Range(cExpirationDate).Copy

Please suggest..

 

[wideboydixon]

You should be able to use the Names collection directly. If your range is named "cExpirationDate" for example, you can do this:

Names("cExpirationDate").RefersToRange.Copy

WBD

 

[VBABEGINER]

First of all, Thank you for replying to query..
And this is Super...You are sharing..Really Thanks for this..Cheers..!!

If Anything on this, more query i will post..

You should be able to use the Names collection directly. If your range is named "cExpirationDate" for example, you can do this:

Names("cExpirationDate").RefersToRange.Copy

WBD