rows(x) and cells(y) are indexes, not counts.

Rows have cells, so your example only pulls the content from the 100000th cell on the 10000th row.

Is your table really this large ?

You could try reading in the entire table using oTable.innerText and see what you get. Otherwise iterate through all the cells
copying each value in turn.

--
Tim Williams
Palo Alto, CA


"tmp2100 via OfficeKB.com" <u21084@uwe wrote in message news:5f6d118e84103@uwe...
Tim:
I presume that to pull in a big table, all I need is to do is, for example,
size the rows and cells counts large enough to match or exceed the size
of the target table ? for example,
Msgbox oTable.rows(10000).cells(100000).innerHTML

In your example, what is the subsequent statement needed to pull the complete
Msgbox
content into the spreadsheet from which the macro is being run ?

================================================== =============================
Tim Williams wrote:
The document object model doesn't psermit a copy/paste operation, but you can access the individual rows/cells and get the
content
from selected ones...

Eg:

Msgbox oTable.rows(2).cells(2).innerHTML

Tim

Tim:
I also found that changing the statement:
[quoted text clipped - 23 lines]

endSub

--
tmp2100

Message posted via http://www.officekb.com