Images overlay cells so deleting rows and columns does not delete the objects.

Just deletes the content in the cells.

I believe Microsoft would get thoroughly blasted by users if objects were
deleted when cells were deleted.


Gord Dibben MS Excel MVP


On Fri, 27 Oct 2006 11:56:02 -0700, JeffH
wrote:

Thanks to all who wrote back.

I didnt try the code that Ron put up but noticed that there were images on
the page for some reason...about 700 of them which were not deleting when
selecting rows/columns or the entire page to delete. I had to "Go
To-Special-Objects" select them all and Cut them. I think Ron's suggestion
would work so I gave him credit.

An intersting case where Microsoft doesnt believe Delete should mean Delete
I guess.

Thank you.

"JeffH" wrote:

Hello. I have read and tired all the relevant posts I can find on this site
including:
1. The ever popular link to contextures
2. Saving as HTML and resaving as a workbook
3. Verifying there are no named ranges

Basically, I have a workbook with one worksheet which contains nothing at
all. I can select the entire worksheet and Delete the contents. There are no
macros, no VBA associated with the worksheet...nothing. This workbook is
about 2mb and I am at my wits end in discovering why. Any suggestions other
than what I have already tried?

Thank you,
Jeff