Posted to microsoft.public.excel.programming
|
|
IF a cell is active THEN...
Whoo-hoo!! It worked and you rock!
And thanks to B Lynn B, too. Thanks y'all!!
Peace,
Keith
"Bernie Deitrick" wrote:
Keith,
If ActiveCell.Address = "$A$1" Then
RunSomeCode
Else
RunSomeOtherCode
End If
You may want to check the sheet name as well - but that depends on your workbook structure
HTH,
Bernie
MS Excel MVP
"Keith in Portland" <Keith in wrote in message
...
Hi all,
I'm trying to have a conditional statement to reference if a cell is active.
If a cell is active, then run some code, if it is not active, then run some
other code.
Any help is most gracious!
Thanks,
Keith
.
|