Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to make a "PrintScreen" on a range and paste it in a doc
Hi all,
In my application, I need to copy a range and paste it in a Word doc. Since every cell in the range has the following foramt: DisplayedText [NumberBehindScence] Only the DisplayedText appear on my worksheet, [NumberBehindScence] is hidden through cell's column width adjustment. So when copied to Word Doc, I want to keep the same visual effect. I'll do it in VBA, could you tell me how to do it. My Excel and Word are 2000. Clara thank you so much for your help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
problem with Linking workbooks via "copy" and "paste link" | Excel Discussion (Misc queries) | |||
Shortcut key for "Paste Options" and "Error Checking" buttons? | Excel Discussion (Misc queries) | |||
Complex if test program possible? If "value" "value", paste "value" in another cell? | Excel Discussion (Misc queries) | |||
how can I make an excel cell "mark" or "unmark" when clicked on? | Excel Discussion (Misc queries) | |||
How can I make a range "dynamic"? | Excel Worksheet Functions |