Thread: run macro on a condition
View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.programming
Per Jessen Per Jessen is offline
external usenet poster
  
Posts: 1,533
Default run macro on a condition
The line miss a closing paranthesis:

If Not Intersect(Target,Range("G1:H1")) Is Nothing Then

-Per

"tkraju via OfficeKB.com" <u16627@uwe skrev i meddelelsen
news:94ce3eac73fe8@uwe...
If Not Intersect(Target,Range("G1:H1") Is Nothing Then
this giving me error

Per Jessen wrote:
Hi

You could use
If Target.address =="$G$1" Or Target.address "$H$1" Then

But I would use this as it is more flexible as it can be used on larger
ranges:

If Not Intersect(Target, Range("G1:H1") Is Nothing Then

-Per

Hi Per
If I write like this will it work:
[quoted text clipped - 24 lines]
changes.Say ,
If whenever I changescell G1 value macro1 should run.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200904/1


Reply With QuoteReply With Quote