Formating a picture to fit cell automaticaly
 

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?

Formating a picture to fit cell automaticaly
 

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

"heartofthebeast" wrote:

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?