Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy an exact cell value (text)
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" </td<td width="103" align="left" </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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy an exact cell value (text)
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. Rasmus wrote: 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" </td<td width="103" align="left" </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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy an exact formula without changing cell reference | Excel Worksheet Functions | |||
exact copy | Excel Worksheet Functions | |||
Exact Copy | Excel Discussion (Misc queries) | |||
Copy exact value from one cell to new formula in another cell | Excel Discussion (Misc queries) | |||
How to do the exact copy of a formula | Excel Worksheet Functions |