I figured out a solution, I thought I'd post it for future users.

I had the problem of data tables which were recalculating during every iteration of a macro and it really slowed me down.

I used the 'Find' function under find and replace drodown menu in the 'home' ribbon of Excel 2007. (I think it's in 'edit' menu on older versions)

I looked for the word TABLE and found the cells I was interested in. Then I deleted only the cells containing the word TABLE and left the rest in case I want to create the table again.

Cheers