Prevoiusly posted message: Unable to remove objects pasted into Excel from HTML grid
 

Original post from kydan47 on Fri, Jul 21 2006 7:03 am

Could not respond to this post because it is too old and has been
closed. I have the same problem and I tried all three of the solutions
proposed by users in the three replies. None worked. The first two
allowed me to select every object on the worksheet except the ones in
question. The third solution produced a cell with 18 point bold
letters that read, "Invalid request" and in the cell beneath it, a
"click here" hyperlink that took me back to the webpage. Following is
the text of the original post (which perfectly describes my problem).
I am desperate for a solution.


Copied & pasted an html page into Excel. Has little check boxes that will can
be checked, but not removed. Can't grab them, deleting columns or rows just
moves them over by one.

Any idea how to get rid of them? Would like to keep the rest of the data.
Have tried using every command or option found, must be missing something.


Thanks in advance

Prevoiusly posted message: Unable to remove objects pasted into E
 

Does the following get rid of too much material:

Sub Macro1()
Cells.Hyperlinks.Delete
ActiveSheet.Pictures.Delete
End Sub
--
Gary's Student
gsnu200701


"X-Ice" wrote:

Original post from kydan47 on Fri, Jul 21 2006 7:03 am

Could not respond to this post because it is too old and has been
closed. I have the same problem and I tried all three of the solutions
proposed by users in the three replies. None worked. The first two
allowed me to select every object on the worksheet except the ones in
question. The third solution produced a cell with 18 point bold
letters that read, "Invalid request" and in the cell beneath it, a
"click here" hyperlink that took me back to the webpage. Following is
the text of the original post (which perfectly describes my problem).
I am desperate for a solution.


Copied & pasted an html page into Excel. Has little check boxes that will can
be checked, but not removed. Can't grab them, deleting columns or rows just
moves them over by one.

Any idea how to get rid of them? Would like to keep the rest of the data.
Have tried using every command or option found, must be missing something.


Thanks in advance