| 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?
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? |
|
#4
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? |
|
#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 | |||
Hybrid Mode
