Hi there,
I'm writing some little macros for Excel to help out with putting pictures into a report.
If I erase an old (already sized and formatted) picture from a document or spreadsheet and then copy in a new one, all formatting and size (size is the most important) are lost. I know how to redo formats (ie left right center etc) but I need some help with automating the sizing.
How can I save the size of an image before erasing it and then reapply these same properties to the new image???
Much thanks in advance!
I'm writing some little macros for Excel to help out with putting pictures into a report.
If I erase an old (already sized and formatted) picture from a document or spreadsheet and then copy in a new one, all formatting and size (size is the most important) are lost. I know how to redo formats (ie left right center etc) but I need some help with automating the sizing.
How can I save the size of an image before erasing it and then reapply these same properties to the new image???
Much thanks in advance!