Delete syntax problem

[anny]

Greetings

I'm having trouble using VB to delete the contents of a table (range
A1040). 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("A1040").Delete ???


Thanks
anny

 

[Jim Cone]

anny,

Use .ClearContents instead of .Delete

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



Greetings
I'm having trouble using VB to delete the contents of a table (range
A1040). 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("A1040").Delete ???

Thanks
anny

 

[Peo Sjoblom]

Try

ClearContents

instead of delete

--
Regards,

Peo Sjoblom

Portland, Oregon

 

[Bri]

thanks to both!
anny