Get the number of the actual column in a range it belongs to 2

[joaopazevedo]

Hi, Thank you for your time

Wanted to know how to get the number of the actual column in reference to a range it belongs to, not to the absolute excel reference of columns.

 

[bluedragon2]

=COLUMN(<where your at>)-COLUMN(<where your reference point is>)

[Blue]Blue[/Blue] [Dragon]

If I wasn't Blue, I would just be a Dragon...

 

[joaopazevedo]

After reading I said, Haaa
It's obvious. But only obvious if you think of it.
Thank you very much

 

[SkipVought]

hi,

the number of the actual column in reference to a range it belongs to

  With Range(TheRange)
    msgbox "The FIRST column in SomeRange is " & .column
    msgbox "The LAST column in SomeRange is " & .column + Columns.Count -1
    msgbox "The NUMBER OF COLUMNS in SomeRange is " & .columns.count

  End with

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[joaopazevedo]

Thank you a lot SkipVought
For your answer in VBA.