hi, i have cells that contain diff. formula and the first time i enter any
one of them then leave it (eg. use arrow key to scroll across columns in a
given row) the worksheet change event is fired. is this a bug because
nothing has changed in the cell (perhaps some recalculate event has fired?).

the reason the above noted behaviour is a problem is because in my
worksheet_change event i execute an
Application.Undo
and this line of code throws an error because nothing there is nothing to
undo because nothing has actually changed. i don't know how to test for
whether there is anything to undo. i found something about the undo list but
can't figure out the syntax to access this "object".
any help would be wonderful...
cheers, pwrob

--
xl help seeker