Hi,

using the following code to clear cells on opening a workbook, however it only clears cells on 1 tab, i want to be able to clear cells from different tabs in the same workbook. Any ideas?

a = MsgBox("WOULD YOU LIKE A BLANK FORM ?", vbYesNo)
If a = vbYes Then Cancel = Range( _" "). _
Select
Selection.ClearContents


thanks