Posted to microsoft.public.excel.programming

Stephen Bullen[_4_] Stephen Bullen[_4_] is offline

external usenet poster

Posts: 205

Automatic Macro Execution Upon Cell Values Changing

Hi Wardides,

how do I tell the worksheet_change event that it should only run if c5
is changed ?

It will always run - you have to test the Target parameter to see if
it's the one you want - such by checking its address, or seeing if it's
inside a named range.

Regards

Stephen Bullen
Microsoft MVP - Excel
www.oaltd.co.uk

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to automatic calculation and macro execution between 3 workbooks?	c	Excel Worksheet Functions	1	July 22nd 05 05:38 AM
Changing cell values between columns with macro	spolk	Excel Programming	1	February 18th 04 12:48 PM
Automatic execution of macro	Paul-André Gollier	Excel Programming	1	January 30th 04 09:03 PM
automatic macro execution	Jos reulen	Excel Programming	4	November 10th 03 03:10 PM

All times are GMT +1. The time now is 04:42 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us