Thread: Running a macro on action
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
OJ[_2_] OJ[_2_] is offline
external usenet poster
  
Posts: 111
Default Running a macro on action
Hi,
replace
If ActiveCell.Address = "$C$3" Then
with
If Target.Address = "$C$3" Then

Hth,
OJ

Reply With QuoteReply With Quote