| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Determine if cell was modified by Enter , Paste or Delete
-- Randy Hi, I am having trouble getting the row number of the cell just modified. If Copy/Paste is used, ActiveCell.Row gives the correct answer. If the cell was cleared with the DEL key, again AC.Row is correct. Problem is the if the cell was modified and then ENTER is hit, AC.Row now gives me the next row number. I need to know the real row that was modified so I can do some stuff to other cells on that row. This is probably easy but I can't find it. Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to determine row of page break on modified presentation sheet? | Excel Discussion (Misc queries) | |||
| Determine a cell's width and enter it in the cell | Excel Discussion (Misc queries) | |||
| dynamically enter name of last modified by in spreadsheet on save | Excel Discussion (Misc queries) | |||
| How do I enter the date last modified in the footer of an Excel d. | Excel Discussion (Misc queries) | |||
| How to determine which button was clicked on the modified right-click menu | Excel Programming | |||
Threaded Mode
