Clearing Excel Cells

Post Reply
User avatar
Jeff Barnes
Posts: 933
Joined: Sun Oct 09, 2005 1:05 pm
Location: Ontario, Canada
Contact:
Contact Jeff Barnes

Clearing Excel Cells

Post by 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.
Thanks,
Jeff Barnes

(FWH 16.11, xHarbour 1.2.3, Bcc730)
Top
User avatar
nageswaragunupudi
Posts: 10721
Joined: Sun Nov 19, 2006 5:22 am
Location: India
Been thanked: 8 times
Contact:
Contact nageswaragunupudi

Post by nageswaragunupudi »

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

G. N. Rao.
Hyderabad, India
Top
User avatar
Jeff Barnes
Posts: 933
Joined: Sun Oct 09, 2005 1:05 pm
Location: Ontario, Canada
Contact:
Contact Jeff Barnes

Post by Jeff Barnes »

Thanks Nageswaragunupudi.

Exactly what I needed.
Thanks,
Jeff Barnes

(FWH 16.11, xHarbour 1.2.3, Bcc730)
Top
Post Reply

Return to “FiveWin for Harbour/xHarbour”