Hi Joe,

I wish to link to a web page copy the information to the
clipboard and paste this as plain text onto an excel
sheet. Any help with achieving this or pointers to
articles would be appreciated.

It might be easier to use a web query. Click on Data Import External
data New Web Query and follow the wizard.

Regards

Stephen Bullen
Microsoft MVP - Excel
www.BMSLtd.ie