Macro to copy portion of each sheet and paste into the first sheet asa picture

  • Thread starter Thread starter XLSRenegade
  • Start date Start date
X

XLSRenegade

I'm new to VBA but have been managing to get by using the recorder. I am trying to create a macro that will copy a specified portion of certain sheets in a workbook, then paste them all as pictures into the first sheet of the workbook.

There are 16 tabs in the sheet. I want to copy 11 of them, then paste them into the first tab, all as pictures. The range of cells I want to copy/paste varies for each sheet.

The macros I have recorded all seem to fail because excel is naming each picture numerically (picture 1, picture 2, etc.).

I'm sure this is a fairly easy task. Can anyone point me in the right direction? Thanks!
 
I'm new to VBA but have been managing to get by using the recorder. I
am trying to create a macro that will copy a specified portion of
certain sheets in a workbook, then paste them all as pictures into
the first sheet of the workbook.

There are 16 tabs in the sheet. I want to copy 11 of them, then paste
them into the first tab, all as pictures. The range of cells I want
to copy/paste varies for each sheet.

The macros I have recorded all seem to fail because excel is naming
each picture numerically (picture 1, picture 2, etc.).

I'm sure this is a fairly easy task. Can anyone point me in the right
direction? Thanks!
Click to expand...

Rename them however you want!

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion
 
Back
Top