Can i use a named range as just the column in a macro

[tonywatsonhelp]

Hi everyone,

Its a long story why so i wont get into it,
but Heres what i want to do

I have a named range called "Total_Names"

I have a macro that does lots of things and one is in the same column as ""Total_Names"
So i was woundering if i could ref "Total_Names" column in my vba code

For example if i was writing it in English it would be something like this:

Column1 = "Total_Names" . column

Range(Column1 & "12") = "Test Data1"

Range(Column1 & "16") = "Test Data2"
end sub

and so if Column1 = Column D then D12 = "Test Data1"

can this be done if so how

Thanks

Tony

 

[Norie]

Tony

Short answer, yes.

However you couldn't do it with the code you posted - you would use Cells instead of Range.

Column1 = Range("Total_Names").Column

Cells(12, Column1) = "Test Data1"

Cells(16, Column1) = "Test Data2"

 

[tonywatsonhelp]

And thats where i was going wrong! trying to do it with range
Thanks very much this is going to be so helpfull
Tony