Forcing a macro to (semi-) automatically run

[Richard Owlett]

I have a chart which can have a range of up to 4000 points.
I frequent want to look at only a specific sub-range.
(Essentially zoom in on an area of interest.)

I wrote a macro which accepts starting and ending values from
particular cells.

I haven't figured out how to force it to run anytime I enter a new
value. If it replotted a 'new' range anytime the spreadsheet
recalculated, that would be fine also.

I could use keyboard shortcut.
BUT, computers should serve user, not vice versa

Thanks

 

[Tom Ogilvy]

The change event for the worksheet fires each time you edit a cell. You
could probably use that to perform the plot

see Chip Pearson's page on events if you are not familiar with them

http://www.cpearson.com/excel/events.htm

 

[Richard Owlett]

The change event for the worksheet fires each time you edit a cell. You
could probably use that to perform the plot

see Chip Pearson's page on events if you are not familiar with them

http://www.cpearson.com/excel/events.htm

Yes, that describes what I want to do.
Now I'll have to read it carefully enough to actually do it