View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
SueDot SueDot is offline
external usenet poster
 
Posts: 20
Default Duplicate a picture image into multiple cells

I have a workbook with 30 identically formatted pages (when printing out) on
three separate worksheets (10 pages per worksheet). Each page also includes
a graphic image of a logo we use. Occasionally, I need to change the logo to
a different image .bmp and have to delete the old and paste the new by hand
30 times. I'm looking for a way to have one location where I can put just
one copy of my image and then have it somehow magically duplicate itself into
the appropriate cells on each of the 30 pages. I've already examined the
info on the McGimpsey website for displaying a picture based on a cell value.
This works wonderfully for displaying just one copy of the image, but I need
to make 30 of them and have them display in their correct locations. Is there
a way to do this?
Thanks in advance for any advice!
--
Susan