Clearing Excel Cells

[Jeff Barnes]

Hi Everybody,

Does anyone know the command to select a range of cells and completely clear that range.

I need to be able to remove the data in the cells and any formatting including the lines around the cell and any shading.

[nageswaragunupudi]

oSheet:Range( <spec> ):Select()
oExcel:Selection:ClearContents()
oExcel:Selection:ClearFormats()

[Jeff Barnes]

Thanks Nageswaragunupudi.

Exactly what I needed.