Dear all,
I need to create a variable to return the number of the column that
the active cell is selected, for example: if the cell selected is in
column B, the number returned by variable is two; if the cell selected
is in column E, the number returned by variable is 5.
Thanks a lot!!!
André.
Don Guillett - 12 Aug 2007 16:32 GMT
msgbox activecell.column

Signature
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett1@austin.rr.com
Dear all,
I need to create a variable to return the number of the column that
the active cell is selected, for example: if the cell selected is in
column B, the number returned by variable is two; if the cell selected
is in column E, the number returned by variable is 5.
Thanks a lot!!!
André.