Dear Friends,
I have inserted the photographs of persons in column range 'd8:d3000'. After inserting the photographs I have to adjust the size of it to fit in that particular cell and look better all the photographs in same size. To avoide this laborious task I need a macro for it. The photographs are not in all rows. Only when there is a entry of new person then I insert his/her photograph and other rows contains the personal information of him. So there may be blank cells in between two photographs and it depend upon how much information of him is available. It may be 2/3/4 or more cells blank between two photographs in column 'd'. I want to resize the photograph 'width = 3 cm, height = 4 cm' automatically resize.

Thanking you in anticipation.

Mukesh