View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Keith in Portland[_2_] Keith in Portland[_2_] is offline
external usenet poster
 
Posts: 1
Default 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



.