ipbr21054
Well-known Member
- Joined
- Nov 16, 2010
- Messages
- 5,227
- Office Version
- 2007
- Platform
- Windows
I use the following code.
BUt when i run it i see a message sub or function not defind.
I use the same call procedure on another button which works so stumped as to why this is an issue
If i remove the call procedure it works to clear contents but put it back & i see the message again
BUt when i run it i see a message sub or function not defind.
I use the same call procedure on another button which works so stumped as to why this is an issue
If i remove the call procedure it works to clear contents but put it back & i see the message again
Rich (BB code):
Private Sub CommandButton1_Click()
Unload InvoiceClearSheetQuestion
Range("G13:G18").ClearContents
Range("L14:L18").ClearContents
Range("G27:L36").ClearContents
Range("G46:G50").ClearContents
MsgBox "ALL CELLS HAVE NOW BEEN CLEARED", vbInformation, "CLEAR ALL CELLS MESSAGE"
Range("G13").Select
Call PasteIfFormulas_Click
ActiveWorkbook.Save
End Sub