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 |
All times are GMT +1. The time now is 05:16 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com