Please help me to find out number of column occured

[pol]

Please help me to find out number of column occured between
activecell and A7

For example current column M7 . I want to find out the number of column
between
the column M7, A7

It would be very helpful to me please help

With thanks
Pol

 

[Jacob Skaria]

Try

=COLUMN()-COLUMN($A$7)-1

If this post helps click Yes

 

[Luke M]

xValue = Range(ActiveCell, "A7").Columns.Count