Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can you write the contents of an Excel Named Range to Word?
Hi: I am looking for any assistance to write the contents of an Excel
Named Range to a Word doc at a book marked location. I have been able to write code to write a single cell to a bookmark, but when I try to write the contents of a range, I don't get any data, although I don't get any errors either; just no text. I am using code to create the named range and it seems to be set up correctly in Excel after the routine runs. I am wondering if my approach is wrong and I should just copy and paste the data from Excel to Word instead, although I thought using a named range might be more efficient instead of using the clipboard. The data I am copying is not going to be more than probably 500 cells. I have written a few macros, but still very much new to this. Any help would be greatly appreciated! Anne |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
2007 - link named excel range to word document | Excel Discussion (Misc queries) | |||
copying the contents of a named range from one location to another | Excel Discussion (Misc queries) | |||
Hyperlink to Named Range Based On Cell Contents | Excel Worksheet Functions | |||
write a macro like the /file copy combine named range in lotus 12 | Excel Programming | |||
Goto a named range using the contents of the active cell | Excel Programming |