| Home |
| Search |
| Today's Posts |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro if condition | Excel Discussion (Misc queries) | |||
| I need a macro to run on a set condition | Excel Programming | |||
| use more than 4 condition in cf without using macro | Excel Worksheet Functions | |||
| Run Macro until a condition is met | Excel Programming | |||
| macro to run only under certain condition - how? | Excel Programming | |||
Threaded Mode
