How to make a "PrintScreen" on a range and paste it in a doc

C

clara

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top