View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
heartofthebeast heartofthebeast is offline
external usenet poster
 
Posts: 1
Default 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?