| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Active Cell
I have a Visual Basic command button on an Excel worksheet. When the command
button is clicked I need the code to make use of the column number of the active cell. How is this found? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel Active Cell
try ActiveCell.Column
this will return 1 for column A -- Gary "gazza" wrote in message ... I have a Visual Basic command button on an Excel worksheet. When the command button is clicked I need the code to make use of the column number of the active cell. How is this found? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel Active Cell
Try something like this
MsgBox ActiveCell.Column activecell.entirecolumn.select or whtatever... -- HTH... Jim Thomlinson "gazza" wrote: I have a Visual Basic command button on an Excel worksheet. When the command button is clicked I need the code to make use of the column number of the active cell. How is this found? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to use the active cell in an Excel formula | Excel Worksheet Functions | |||
| How do I get the coordinates of the active cell in Excel? | Excel Discussion (Misc queries) | |||
| Row select mode to highlight active row of active cell | Excel Discussion (Misc queries) | |||
| referring to formula in a non active cell from active cell | Excel Discussion (Misc queries) | |||
| How do I shade the active cell in excel | Excel Worksheet Functions | |||
Linear Mode
