Excel VBA Column

M

magix

Hi,
This is about Excel VBA.
How do I detect if the active cell is in Column A or not ?
My pseudo code is like this:

If any active cell is selected within Column A then
Process normally
else 'current active cell is in other columns
MsgBox "You are not in Column A", 16


please help. thanks.

Regards,
Magix
 
B

Bob Phillips

If Activecell.Column = 1 Then
...

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
D

Don Guillett

here is something I have used

Sub colA()
If ActiveCell.Column = 1 Then
mycol = 10
Else
mycol = ActiveCell.Column
End If
MsgBox mycol
 
Top