anny,

Use .ClearContents instead of .Delete

Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware



"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