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.