Is there a way to resize the image in memory before inserting into spreadsheet?

I'm sure VB6 has a way, but don't think it crosses over to vba.

TIA