Forcing a macro to (semi-) automatically run
 

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

Forcing a macro to (semi-) automatically run
 

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

--
Regards,
Tom Ogilvy


"Richard Owlett" wrote in message
...
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

Forcing a macro to (semi-) automatically run
 

Tom Ogilvy wrote:
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 ;)