Here's one for you experts - it's driving me crazy:

I use Excel for a lot of strange and unusual things and I have a cell
(formatted as text) value that is:

Hi,<br<br<table border="0" cellpadding="0" cellspacing="0"
style="border-collapse: collapse" bordercolor="#111111" width="400"
id="AutoNumber1"<tr<td width="102" align="left"<a
href="productDetails/8809113254001"<img border="1"
src="resources/cache/front/70/90/8809113254001_70x90.jpg"
style="border-style:solid; border-color:#000000; "</a</td<td width="102"
align="left"&nbsp;</td<td width="103" align="left"&nbsp;</td<td
width="103" align="left"</td</tr</table<br<br


Please note, within Excel it's NOT HTML - it's an actual text value in
Range("A2").

Have you got any tips for copying this cell to the Windows copy buffer ? If
I use Range("A2").Copy, it'll just copy a lot of ############'s to the
buffer as the value is so long that Excel cannot display it as it would
normally do.

I hope you can help!

Rasmus