Resize image by pixel while inserting

Hi,

i got the code by google search for resizing the imge while inserting in excel sheet. But the resizing happens by the height and width of the column , where i want the image resized to 50px(width) X 50 px(height). Please let me know what changes to be done.

Please Login or Register  to view this content.

Thanks in advance ,
Mayur

Hi mayurpatil,

Try the following( changes in red):

Please Login or Register  to view this content.

It is a best practice to declare all variables. If you misspell a variable in your code, VBA will silently assume it is a Variant variable and go on executing with no clue to you that you have a bug. Go to the VBA development window, click Tools, Options, and check "Require Variable Declaration." This will insert the following line at the top of all new modules:

Please Login or Register  to view this content.

This option requires all variables to be declared and will give a compiler error for undeclared variables.

Lewis