View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
anny
 
Posts: n/a
Default Delete syntax problem

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