Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Function to return a previous cell value
I want to write a VBA function to do the following:
Function resides in cell B1 and references the value of A1 (A1 references other parts of the workbook). Value of A1 is 5, so value of B1 is also 5. User changes some input data and A1 changes to 17, so B1 is now 17. User makes additional changes resulting in A1 changing to *KEY_ERR. VBA function in B1 tests for this condition and returns the last good value in A1 (17). Any suggesstions? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to return to previous cell? | Excel Discussion (Misc queries) | |||
return cursor to previous cell? | Excel Discussion (Misc queries) | |||
Return Path to previous cell | Excel Discussion (Misc queries) | |||
Select cell, Copy it, Paste it, Return to Previous cell | Excel Discussion (Misc queries) | |||
Return to a previous cell | Excel Discussion (Misc queries) |