Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
please help! Linking a picture to a cell and recalculating automatically | Excel Discussion (Misc queries) | |||
Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
Conditional Formating for a cell based on another cell's value | Excel Discussion (Misc queries) | |||
Cell to follow content AND/OR formating of another cell | Excel Discussion (Misc queries) | |||
cell color index comparison | New Users to Excel |