Copy & Paste from Webpage with IE


M

Mike Hogan

When using IE, if I copy a certain table from a webpage then paste it into a
worksheet,
I lose some of the gridlines for the cells. I've tried all Paste Special
options, but they put
each row of the table into a single cell. The only option that puts the
data into separate
cells is HTML but then the gridlines are gone. If I clear the cell
contents, the only way
I've found to get the gridlines back is to merge then unmerge the cells.
This did not
happen when I was using Netscape as my browser, but I had to rebuild my
system
from scratch and hoped I could use just one browser (IE) for everything.

Does anyone have an explanation or a way to avoid this? Advice will be
appreciated.

Mike
 
Ad

Advertisements

G

Guest

I believe if you copy from the data that doesn't display the gridlines and
then PASTE SPECIAL and select VALUES into a new worksheet it will paste the
data and retain the gridlines.
 
Ad

Advertisements

M

Mike Hogan

That works, but it requires opening another worksheet plus extra steps
to change sheets and copy/paste. The webpage table contains financial
data that is updated daily, so I'm looking for a quick way to make
changes to the workbook I use to track it. I had a macro to do it with
Netscape and could probably create another for IE but would like to
know why copy/paste works differently depending on the browser used.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top