Excel Active Cell

[Guest]

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?

 

[Gary Keramidas]

try ActiveCell.Column

this will return 1 for column A

 

[Guest]

Try something like this

MsgBox ActiveCell.Column

activecell.entirecolumn.select

or whtatever...