| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Paste Special a string value
I have the following piece of code:
ActiveCell.Offset(1, 0).Value = strA Is there anyway of populating the cell with the value of StrA as a pastespecial values? Because StrA has a different format (font and size) than where it is being posted to. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Paste Special a string value
I think your options are to either format the "to" cell or use the copy
method to capture the "from" cell format. "carl" wrote: I have the following piece of code: ActiveCell.Offset(1, 0).Value = strA Is there anyway of populating the cell with the value of StrA as a pastespecial values? Because StrA has a different format (font and size) than where it is being posted to. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Paste Special a string value
I thought as much.
Thanks anyway. "JLGWhiz" wrote: I think your options are to either format the "to" cell or use the copy method to capture the "from" cell format. "carl" wrote: I have the following piece of code: ActiveCell.Offset(1, 0).Value = strA Is there anyway of populating the cell with the value of StrA as a pastespecial values? Because StrA has a different format (font and size) than where it is being posted to. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Paste and Paste Special No Longer Working - Excel 2003 | Excel Discussion (Misc queries) | |||
| Automating copy/paste/paste special when row references change | Excel Programming | |||
| In Excel: add a Paste-Special Option to paste IN REVERSE ORDER. | Excel Worksheet Functions | |||
| How do I capture user paste action and convert to Paste Special | Excel Programming | |||
| Dynamic Copy/Paste Special Formulas/Paste Special Values | Excel Programming | |||
Linear Mode
