ExcelBanter - Please help me to find out number of column occured

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Please help me to find out number of column occured (https://www.excelbanter.com/excel-discussion-misc-queries/237235-please-help-me-find-out-number-column-occured.html)

pol

Please help me to find out number of column occured

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

Please help me to find out number of column occured

Try

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

If this post helps click Yes
---------------
Jacob Skaria

"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

Luke M

Please help me to find out number of column occured

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

All times are GMT +1. The time now is 09:05 AM.