Formating a picture to fit cell automaticaly

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi all. I realy hope someone can help with this.. At the minute to format the
size of the photo i am putting into a report i have to insert the photo then
go to the photo properties and manualy alter the size to make it fit the
cell. When i am doing a report with over 130 images this can become very
tedious and annoying.

Is there a quick fix macro i cam insert to the workbook or something??

If so .. what is it as i know nothing about macros or how to write one?
 
It depends on what you want to do exactly

you can go through every picture on a sheet by:
'-----------
for each pict in activesheet.shapes

next pict
'-----------
if you have to alter every photo the same way, with the same numbers,
you can record a macro once (Tools->Macro->Record) and then put it
between the for...each...next-loop!

If you have any problems after that, just ask again.

Hth

Cheers Carlo
 

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

Similar Threads

Resize cell to fit picture 3
adding multiple pictures at once instead of one at a time 1
Macro to insert pictures in comments 8
Insert pictures 5
Excel Highlighting duplicates 0
Insert Picture into a cell 1
How do I insert a photo into a specific cell? 3
To much space in my cell? 3

Back
Top