G
Guest
I'm creating a macro that's a basic zero out of all unprotected cells.
However, I want the macro to return the active cell/window view back to the
top of the sheet once the macro is finished running. What is the command I
put at the end of the macro? Currently, I have this:
Private Sub CommandButton3_Click()
Application.ScreenUpdating = False
ActiveCell.FormulaR1C1 = "0"
Range("K109").Select
ActiveCell.FormulaR1C1 = "0"
Range("K126").Select
End Sub
Thanks! Michele S.
However, I want the macro to return the active cell/window view back to the
top of the sheet once the macro is finished running. What is the command I
put at the end of the macro? Currently, I have this:
Private Sub CommandButton3_Click()
Application.ScreenUpdating = False
ActiveCell.FormulaR1C1 = "0"
Range("K109").Select
ActiveCell.FormulaR1C1 = "0"
Range("K126").Select
End Sub
Thanks! Michele S.