<HELP> Excel has too many issues (VBA) <HELP>

[Von Shean]

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. How do i detect that weather a cell has a formula or not?
5. In a worksheet, how can i come to know what is the location of the cell
that defines the size of the data matrix?
6. How can i get the user action of insert/detele of rows/columns?

Regards,

 

[David McRitchie]

see microsoft.public.excel. programming where you also posted, and
Tom Ogilvy had already supplied a better answer than than my attempt
that I was working on here. You will see mine after his. Once 12 hours
has elapsed other can go to that thread at.
http://google.com/[email protected]

This newsgroup was dropped by Microsoft a long time ago, but is
once again carried on the Microsoft servers. The main groups are
excel.newusers, excel.misc, excel.worksheet.functions, and
excel.programming More information from my experience in
Excel Newsgroups & Searching Newsgroups
http://www.mvps.org/dmcritchie/excel/xlnews.htm