Copy an exact cell value (text)

[Rasmus]

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

 

[Dave Peterson]

I'm betting that it copies ok. But when you do your edit|paste special|values,
you get the ####'s.

If that's true, try changing the numberformat of the receiving cell to General.
(Cells formatted as Text have trouble displaying long strings.)

If this isn't the problem, you may want to post more of your code and a few more
details.