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


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!
 
Ad

Advertisements

G

GS

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!

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
 

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