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.