Clearing a Sheet of Everything (including pictures) 1

[IdoMillet]

I can clear all cell content of a sheet by calling:

xlsheet.Cells.Clear

However, I need to clear the sheet from ALL content, including pictures (which remain after the call above).

I cannot delete & recreate the sheet (I need to just clear its content).

Any suggestions?

Thanks,
- Ido

Visual CUT & DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[SkipVought]

Hi,

dim sh as shape
xlsheet.Cells.Clear
for each sh in xlsheet.shapes
  sh.delete
next

Skip,

_{[red]Be advised:[/red] The dyslexic, agnostic, insomniac, lays awake all night wondering...
"Is there really a DOG?"}

 

[IdoMillet]

Thanks, Skip.

I'm trying:

xlsheet.Shapes.SelectAll
xlApp.Selection.Delete

If that dioesn't work, I'll try your approach.

Cheers,
- Ido

Visual CUT & DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[IdoMillet]

The simpler approach I tried seems to work well.

Thanks for the suggestion though.

Regards,
- Ido

Visual CUT & DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[SkipVought]

xlsheet.Shapes.Delete

Skip,

_{[red]Be advised:[/red] The dyslexic, agnostic, insomniac, lays awake all night wondering...
"Is there really a DOG?"}