M
Miree
I have a code, which works when i select run but i can not connect it to a
command button, I can get the code to work if i paste in to the work book(but
not the command button) but can not get it to work in the worksheet where
command button is.
Sub AutoNumber()
' AutoNumber Macro
Sheets("Formulations").Select
i = Range("A2") + 1
Sheets("Formulation").Select
Range("E17:E18") = i
End Sub
command button, I can get the code to work if i paste in to the work book(but
not the command button) but can not get it to work in the worksheet where
command button is.
Sub AutoNumber()
' AutoNumber Macro
Sheets("Formulations").Select
i = Range("A2") + 1
Sheets("Formulation").Select
Range("E17:E18") = i
End Sub