ipbr21054
Well-known Member
- Joined
- Nov 16, 2010
- Messages
- 5,232
- Office Version
- 2007
- Platform
- Windows
Morning,
I have the code below being used on a worksheet & all works fine.
I needed the same thing for another worksheet so i copied the code & changed the range.
What happens now is i see the IF statement in the cells also being cleared.
Dont see why on one sheet it doesnt do it but on this sheet it does ?
Do you see an issue or can you please advise another code which will not delete the IF statement in the cells.
Thanks
I have the code below being used on a worksheet & all works fine.
Rich (BB code):
Private Sub ClearSheet_Click()
Range("A4:H28").ClearContents
Range("B1:C1").ClearContents
Range("A4").Select
End Sub
I needed the same thing for another worksheet so i copied the code & changed the range.
What happens now is i see the IF statement in the cells also being cleared.
Dont see why on one sheet it doesnt do it but on this sheet it does ?
Do you see an issue or can you please advise another code which will not delete the IF statement in the cells.
Thanks