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

Luke M
*Remember to click "yes" if this post helped you!*


"pol" wrote:

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