Clear cell (VBA code)

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

Hi,

not sure if i made it clear. Basically when a user opens the excel document they are asked if they, "would like a blank form", if yes it delete's the data from the cells identified between the "" marks. It however only deletes the cells in the first tab. I basically need to know how when identifying the cells to delete how i can tell it what tab to delete the cells from,

any ideas??

Hi,

thanks, but now sure it does what i need it to.

Basically when the user opens the file they are asked the quesiton "WOULD YOU LIKE A BLANK FORM ?" (msg box) if the user clicks on yes (they want a blank form) then the code deletes cells A1 and C1 on sheet 1 and deletes cell B2 and D3 on Sheet 2,

any ideas??