how do find out the column of the active cell in a macro?
 

I want to find out the column of the presently active cell in a macro in
excel. I want to do this so the macro can test to see if the present cell is
in a particular column. Can anybody help?

how do find out the column of the active cell in a macro?
 

One way:
TheCol = ActiveCell.Column
"Neill Lee" <Neill wrote in message
...
I want to find out the column of the presently active cell in a macro in
excel. I want to do this so the macro can test to see if the present cell
is
in a particular column. Can anybody help?

how do find out the column of the active cell in a macro?
 

HTH

MsgBox ActiveCell.Column

"Neill Lee" wrote:

I want to find out the column of the presently active cell in a macro in
excel. I want to do this so the macro can test to see if the present cell is
in a particular column. Can anybody help?

how do find out the column of the active cell in a macro?
 

Thank You! It works!!!

"Otto Moehrbach" wrote:

One way:
TheCol = ActiveCell.Column
"Neill Lee" <Neill wrote in message
...
I want to find out the column of the presently active cell in a macro in
excel. I want to do this so the macro can test to see if the present cell
is
in a particular column. Can anybody help?

how do find out the column of the active cell in a macro?
 

Thank You! It works!!!

"Jim Thomlinson" wrote:

HTH

MsgBox ActiveCell.Column

"Neill Lee" wrote:

I want to find out the column of the presently active cell in a macro in
excel. I want to do this so the macro can test to see if the present cell is
in a particular column. Can anybody help?