get column number from a named range

[divuraj]

Hi,

this is an urgent assignment i am working on and i am stuck with a vba code.

i have a named range "Analogues" which refers to D4 now, but the user can add or delete columns, so i am trying to use named range in my code.

i am trying to get the column position of this cell by

ColNum = Range("Analogues").column which is giving me a Range Global oject failed error.

can anyone please help.

Thanks,
div.

 

[Peter_SSs]

That line of code appears to be okay. Perhaps you need to tell us more about how the named range is defined, what the rest of your code is, where that code is placed etc.

 

[divuraj]

Thanks for a quick response.

This is on click of a button within a form:

Public Sub cmdPre_Click()
Dim ColNum As Variant

ColNum = Range("Analogues").Column
Call ExportToAnalogues("Analogues")

End Sub

after this i am calling another procedure which works fine. Thanks for any help !

 

[Peter_SSs]

What version of Excel are you using?

How is your named range defined?