thank you for the extensive instructions, but i have no need for a pull down
situation that will change the picture. i just want one picture in one spot,
that will automatically size to a range of cells, and that picture has to
come from a jpg file not from another spot within the XL file. i have to try
to keep the file size down, my client is very specific about that.

from everything i have learned today, it seems to me the only way i can do
what i want to do is to manually scale each picture when i insert it.

thank you for trying.

"Ron Coderre" wrote:

> Ok, Cory
>
> You now understand that you can't put a picture "in" a cell, but you can
> place a picture over a cell, or cells, right? So, let's go from there.
>
> For a non-VBA solution, see if this works for you:
> Assumption: Pictures are stored on Sheet2 to be dynamically shown on Sheet1.
>
> Select Sheet2 and turn off Grid Lines
> (Tools>Options>View tab:Uncheck Grid Lines)
> 1)For each picture to be displayed:
> 1a. Insert>Picture from file. (select picture, put it in the sheet and
> resize it).
> 1b. Select the range of cells that contains the picture.
> 1c. Name that range of cells, using the prefix "pic" followed by the
> dropdown list text:
> Example for a picture of an Elephant on cells A2:D10:
> Select those cells
> Insert>Name>Define
> Name: picElephant
>
> 2)Build your data validation list on a cell in Sheet1 and pick one of the
> items.
> If you need help: use Debra Dalgleish's site:
> http://www.contextures.com/xlDataVal01.html
>
> 3)Create a dynamic range name that refers to that cell:
> Insert>Name>Define
> Name: ShowMyPic
> RefersTo: =INDIRECT("pic"&Sheet1!$A$1)
> ...or whatever cell you chose.
>
> 4)Copy/Paste one of the pictures from Sheet2 to the display cell on Sheet1.
>
> 5)With picture selected, type this in the formula bar, then press [Enter]:
> =ShowMyPic
>
> The picture will be replaced by the picture referred to by the dropdown list.
>
> Each time you select a different item in the list, the associated picture
> will appear in the picture box and resize appropriately.
>
> Does that help?
>
> ***********
> Regards,
> Ron
>
> XL2002, WinXP-Pro
>
>
> "CORY" wrote:
>
> > what i learned from that website was this:
> >
> > "Since pictures in XL can't be placed in a cell, but rather float on top of
> > the sheet"
> >
> > that is what i want to do, is place a pictue that spans from (for example)
> > E40 to Q61. it sounds like i can't do that. i don't really know anything
> > about VBA (i don't even know what that stands for)
> >
> > cory
> >
> > "Ron Coderre" wrote:
> >
> > > Still missing info, but based on what you've shared so far maybe this can work:
> > >
> > > Check JE McGimpsey's excellent website:
> > > http://www.mcgimpsey.com/excel/lookuppics.html
> > >
> > > If you decide to use the VBA approach (highly recommended), just make sure
> > > that the pictures in Excel are resized to the same dimensions. If you prefer
> > > a non-VBA approach let us know.
> > >
> > >
> > > Does that help?
> > >
> > > ***********
> > > Regards,
> > > Ron
> > >
> > > XL2002, WinXP-Pro
> > >
> > >
> > > "CORY" wrote:
> > >
> > > > yes, i know how to do that, i was wondering if i could put a formula in that
> > > > first cell that the picture starts from that will tell the photo where to
> > > > end, so i don't have to resize every photo i put in my report. it will
> > > > greatly reduce my time if i can have the photo automacially size to a
> > > > specific range of cells upon inseriton of the photo.
> > > >
> > > > is this possible?
> > > >
> > > > "Ron Coderre" wrote:
> > > >
> > > > > When you insert a picture in Excel, the graphic will start in the active cell
> > > > > on the active sheet and extend down and to the right according to the size of
> > > > > the picture.
> > > > >
> > > > > To change the size you can left-click and hold on any of the "sizing
> > > > > handles" of the picture and and drag to resize it.
> > > > >
> > > > > Does that help?
> > > > >
> > > > > ***********
> > > > > Regards,
> > > > > Ron
> > > > >
> > > > > XL2002, WinXP-Pro
> > > > >
> > > > >
> > > > > "CORY" wrote:
> > > > >
> > > > > > the only thing that i want to be automatic is the placement of the picture,
> > > > > > like i want it to start at this cell and go to that one. what i am currently
> > > > > > doing is saying "insert" picture, so if that makes the file local to the
> > > > > > workbook then yes they will be local to the work book. i am not sure how to
> > > > > > awnser your last question. i am kind of new to excel.
> > > > > >
> > > > > > "Ron Coderre" wrote:
> > > > > >
> > > > > > > There are ways to work with pictures in Excel, but a little more info would
> > > > > > > be helpful.
> > > > > > >
> > > > > > > Do you want an automatic method for those pictures to be selected or changed?
> > > > > > > Will the pictures be stored in the workbook or are you hoping to retrieve
> > > > > > > them from a network location?
> > > > > > > Do you want the proces controlled by VBA or via formulas?
> > > > > > >
> > > > > > > ***********
> > > > > > > Regards,
> > > > > > > Ron
> > > > > > >
> > > > > > > XL2002, WinXP-Pro
> > > > > > >
> > > > > > >
> > > > > > > "CORY" wrote:
> > > > > > >
> > > > > > > > how can i insert a picture to automatticaly go into a specific range of
> > > > > > > > cells every time. all the pictues will be the same resoulution.