Simple VB operation needed for excel Macro
Posted on 2003-10-22
I could really use a macro that can perform the following function:
Delete the contents of the last non-empty cell in the column before the active cell.
Say the active cell is B5, I would like the macro to delete the contents of the last non-empty cell in column A (so if A1-A10 is a list, delete the contents of cell A10). If possible B5 would return to be the actice cell.