vba - ClearContents not working?

[gamerosko]

Hi guys, just simple fast one - Any idea why if I put into my code only the first line below, clearing of the whole sheet does not work & if put another one then it is working.. ?
Checked for protected, merged etc.. nothing such like this there.. ;o)

ThisWorkbook.Sheets("Data").Cells.ClearContents
ThisWorkbook.Sheets("Data").Cells.ClearContents

Thanks, Gamca

 

[footoo]

With only one line, what happens if you step through the macro via F8 ?