Column name

[muimui]

I am just wondering if there is any easy way to find out the column name.
I'm trying to populate a validation list in wkA from another worksheet (eg wkB) (which I dont' think it'll work, however, if you know how it'll work let me know) and I copied the list and transpose it on a row on wkA. However, i know what the end of the row is but need the name of the column to reference it correctly. Anyone?

 

[nath]

Hi muimui,

I'm not exactly sure what you want to do. Here are a few comments though:

To get the column if you have a specific cell you can use:

myCell.EntireColumn

myCell beign any range expression. But I noticed that the result of myCell.EntireColumn.Name will be something like "=Sheet1!$E:$E" even if the column has got a name. One way round is something like the following:

...
Dim x As Name
Dim myCell as Range

Set myCell = ...
    
For Each x In Names
    If x.RefersTo = myCell.EntireColumn.Name Then
        MsgBox x.Name
    End If
Next x
...
[\code] 

It looks very long winded to me but it should work.

Hope this helps,

Nath