software

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
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.

quot;Mike Hoganquot; wrote:

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

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.

jdc wrote:
gt; I believe if you copy from the data that doesn't display the gridlines and
gt; then PASTE SPECIAL and select VALUES into a new worksheet it will paste the
gt; data and retain the gridlines.
gt;
gt; quot;Mike Hoganquot; wrote:
gt;
gt;
gt;gt;When using IE, if I copy a certain table from a webpage then paste it into a
gt;gt;worksheet,
gt;gt;I lose some of the gridlines for the cells. I've tried all Paste Special
gt;gt;options, but they put
gt;gt;each row of the table into a single cell. The only option that puts the
gt;gt;data into separate
gt;gt;cells is HTML but then the gridlines are gone. If I clear the cell
gt;gt;contents, the only way
gt;gt;I've found to get the gridlines back is to merge then unmerge the cells.
gt;gt;This did not
gt;gt;happen when I was using Netscape as my browser, but I had to rebuild my
gt;gt;system
gt;gt;from scratch and hoped I could use just one browser (IE) for everything.
gt;gt;
gt;gt;Does anyone have an explanation or a way to avoid this? Advice will be
gt;gt;appreciated.
gt;gt;
gt;gt;Mike
gt;gt;
gt;gt;
gt;gt;