| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy range and paste as picture
In excel you can copy something and then click Shift + Edit to chose
paste as picture. What is the VBA equivelant of this. The reason that I am wondering is that the range that I have changes sizes and it needs to fit into an area that can not change sizes. I know I will no longer be able to perform data manipulation on it but that is ok. I just need the picture. Thanks, Jay |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copy range and paste as picture
On Mon, 28 Apr 2008 11:52:17 -0700 (PDT), jlclyde
wrote: In excel you can copy something and then click Shift + Edit to chose paste as picture. What is the VBA equivelant of this. The reason that I am wondering is that the range that I have changes sizes and it needs to fit into an area that can not change sizes. I know I will no longer be able to perform data manipulation on it but that is ok. I just need the picture. Thanks, Jay The easiest way to find out is to record a macro while doing the copying/pasteing. Lars-Åke |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copy range and paste as picture
On Apr 28, 2:22*pm, Lars-Åke Aspelin
wrote: On Mon, 28 Apr 2008 11:52:17 -0700 (PDT), jlclyde wrote: In excel you can copy something and then click Shift + Edit to chose paste as picture. *What is the VBA equivelant of this. *The reason that I am wondering is that the range that I have changes sizes and it needs to fit into an area that can not change sizes. *I know I will no longer be able to perform data manipulation on it but that is ok. *I just need the picture. Thanks, Jay The easiest way to find out is to record a macro while doing the copying/pasteing. Lars-Åke Lars, I thought I had tried that with this problem. Apparently I was wrong. It worked great and now i have a module setup to copy and paste as a picture. Jay |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy picture and paste hyperlink | Excel Worksheet Functions | |||
| copy range and paste into every 3rd cell of new range | New Users to Excel | |||
| Copy and Paste Chart as Picture into another workbook or worksheet | Charts and Charting in Excel | |||
| Macro to copy, paste in a range and then delete | Excel Discussion (Misc queries) | |||
| CheckBox Code to copy & paste range | Excel Discussion (Misc queries) | |||
Linear Mode
