VBA - Inserting, Selecting, Moving Pictures?

Hi, You could have a play with this.
This code originally related to small pictures of Flags that had been already inserted in the sheet.
The code just arranges then across & down the sheet.

Please Login or Register  to view this content.

Regards Mick

Thanks for the quick reply. Do I need to do anything special to have that code work, other than copying and pasting? (Forgive my beginner knowledge)

It is returning a "Compile Error: Invalid outside procedure" and the "True" in the code is highlighted.

Thanks again for your help.

Hi, I don't quite understand your error ,but try this.
Right click your sheet tab. This sheet should have pictures (visible) Inserted from the drawing tool bar.
Select "View code", VB window appears.
From the VB Toolbar Select "Insert", "Module". New window appears. Paste the entire code below into the new window.
Close VB Window.
Click "Alt+F8" Macro Dialog box appears, Select the code "Pic", Click run fron the Right hand side Menu.
Pictures in you sheet should be aligned, across & down the sheet.(Hopefully)

Please Login or Register  to view this content.

Regards Mick

Mick,

That is great!!! It is working like a charm. One question, what part of the code do I need to change to adjust the resulting size? In other words, the pictures are reduced, which I want, but not quite this small?

Thanks again, you are a huge help!!!!

hi, What you need to do is play with the Variables"c" & "t", as shown below.
I should change one Variable at a time and then review the result.
It very much dependent on what you want to achieve.

Please Login or Register  to view this content.

Regards Mick