Try

ClearContents

instead of delete

--
Regards,

Peo Sjoblom

Portland, Oregon




"anny" wrote in message
...
Greetings

I'm having trouble using VB to delete the contents of a table (range
A10:P40). The cells just contain values, no formulas. The table is
formatted with borders, and I don't want those deleted.

Is the syntax Worksheets("Data").Range("A10:P40").Delete ???


Thanks
anny