Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi there,
I have a VB.NET application which opens a new Excel workbook (and obviously worksheet). The cell values in the worksheet depend on certain formulae, therefore the sheet Calculate event is triggered whenever a calculation occurs. My problem is that I can't find a way within this event to find out exactly which cell has changed. This is possible with the sheet Change event, because it passes back the changed row as a parameter, but unfortunately this event event doesn't get triggered when a calculation occurs, so I can't use it. Are there maybe any Excel.Range events that I can use to resolve this issue ? Help ! Gordon. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel screen capture to capture cells and row and column headings | Excel Discussion (Misc queries) | |||
EXcel Capture Data into one cell | Excel Worksheet Functions | |||
capture last cell in column | Excel Discussion (Misc queries) | |||
How do I capture a text cell as a value to be able to sum? | Excel Worksheet Functions | |||
How to automatically capture a tab name in a cell? | Excel Worksheet Functions |