#1   Report Post  
johnT
 
Posts: n/a
Default start a macro

i would like to start a macro only if a particular range
of cells have been recalculated
  #2   Report Post  
Don Guillett
 
Posts: n/a
Default

right click sheet tabview codein the left window select worksheet in the
right select workshet CHANGE.in the macro

if target.address="$A$1" then call mymacro


--
Don Guillett
SalesAid Software

"johnT" wrote in message
...
i would like to start a macro only if a particular range
of cells have been recalculated



  #3   Report Post  
johnT
 
Posts: n/a
Default

How can i get it to run if i change a range of cells?
-----Original Message-----
right click sheet tabview codein the left window select

worksheet in the
right select workshet CHANGE.in the macro

if target.address="$A$1" then call mymacro


--
Don Guillett
SalesAid Software

"johnT" wrote in

message
...
i would like to start a macro only if a particular range
of cells have been recalculated



.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Playing a macro from another workbook Jim Excel Discussion (Misc queries) 1 February 23rd 05 10:12 PM
How can I run a macro in the background whilst a UserForm is visib cdb Excel Discussion (Misc queries) 3 February 10th 05 06:58 PM
Date macro Hiking Excel Discussion (Misc queries) 9 February 3rd 05 12:40 AM
Macro and If Statement SATB Excel Discussion (Misc queries) 2 December 3rd 04 04:46 PM
Inserting Blank Rows Macro? Michael Saffer Excel Worksheet Functions 2 November 9th 04 06:23 PM


All times are GMT +1. The time now is 05:34 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"