1. either store the value before it is changed, or you can record the new
value and immediately issue Application.Undo. This would be done in the
Change event

2. Most macro actions clear the undo history, so except for the above
usage, undo is not very workable in macros.

3. Change is fired by a manual or programmatic change to the cell(s) in a
worksheet. Changes caused by calculation are not stored or available unless
you made a copy of all cell values prior to the calculation and compared it
to the current state.

4. Possible msgbox Activecell.currentRegion.Address

5. In xl2000 and earlier, there is no event which fires specifically when a
row or column is inserted or deleted.

--
Regards,
Tom Ogilvy


Von Shean wrote in message
...
I have a list of questions that i need clarification on. If anyone has
answers to any of these, a reply would be of great help. All the question
are related to VBA.

1. How do i access previous values of a cell when detecting a change?
2. How can i access applications undo history?
3. In Worksheet_change how can i get the list of cells that have changed
due
to calculations?
4. In a worksheet, how can i come to know what is the location of the cell
that defines the size of the data matrix?
5. How can i get the user action of insert/detele of rows/columns?

Regards,