| Home |
| Search |
| Today's Posts |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
Maintaining formatting - Excel = Word
Copy and paste will work as the clipboard takes what it sees (kind
of!), and you can even use copy and paste in the macro, but I would not recommend it. I agree that it's the use of strings, but there is no need to use strings AppWd.bookmarks("Fred").range=range("A1").value works just as well as storing the value of the cell in a variable first BUT you don't actually need to use the value AppWd.bookmarks("Fred").range=range("A1").text would give you the formatted text |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| MS Word like formatting in Excel | Excel Discussion (Misc queries) | |||
| Maintaining currency formatting in a Mail Merge? | Excel Discussion (Misc queries) | |||
| how to keep excel formatting when merging to word? | Excel Discussion (Misc queries) | |||
| Maintaining Text Formatting in a Lookup | Excel Discussion (Misc queries) | |||
| Maintaining column formatting when copying a row to another sheet based on a value | Excel Programming | |||
Threaded Mode
