Conversion of a simple Lotus macro to Excel

Posted by Ralph on October 24, 2001 10:09 AM

Would like to convert the following Lotus 1-2-3 commands from a macro to an Excel macro:
{Edit}{Backspace}{Home}-~{down}

Can anyone Help?

Posted by mseyf on October 24, 2001 10:21 AM

you can try this:

Sub Old123Macro()
ActiveCell = "-" & Left(ActiveCell.Formula, Len(ActiveCell) - 1)
ActiveCell.Offset(1, 0).Select
End Sub