Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
macro to find cell content in sheets and make sheet active | Excel Discussion (Misc queries) | |||
Find last cell in a column, Delete its contents and make it active | Excel Worksheet Functions | |||
Find address of active cell | Excel Worksheet Functions | |||
Macro to find the first cell in a column with different data | Excel Discussion (Misc queries) | |||
Find active cell | Excel Programming |