Do you have any merged cells in the worksheet that you are trying to
paste into?

Does it still work using Excel 97 (i.e. no recent changes to the web
site)?

Pete

On Jan 30, 12:52*pm, DaveM wrote:
I have both excel 97 and 2000 running on sperate pcs.

I have been running a routin for a couple years on the 97 version
where I manually copy a web page (Ctl A and Ctl C) and then paste the
contents
into excel (ctl V). *From there i run a macro that cleans up the the
content into the raw data I need. *Been working well, no issues.

I'm now trying to do the same routine on my other box w/ Excel 2000 on
windows XP. *When i try to manually paste the web page data into Excel I
recieve a message "Microsoft Excel cannot paste the data".

I've looked at MS Knowledge base for this type of error with no
results or help. *I've also posted here previously and rec'd no replies. *
Hate to think I've got everyone stumped on this one? *LOL

Any thoughts or help would be appreciated.

Thx
Dave