Auto Resize Pasted Picture to merged cell

Hi... To ALL...

I get one macro that insert picture from disk to selected cell, then auto resize that picture to merged cell size.

But, now i intend to use that same code to PASTE a picture (from System Clipboard) then resize to merged cell size

PASTING to selected merged cell, it works fine...
But.. The resize,... Not that fine.

Here is the code i intend to use;

Please Login or Register  to view this content.

I get ERROr in this line;

If Target.Cells.Count = 1 Then ...

Can someone help me in this...

THANKs

Originally Posted by mrice

Replace Target with Selection as you don't appear to have specified what range Target is?

Yes, you are right, there is another part of the code, like this;

Please Login or Register  to view this content.

BUT, after some more research, i have come up with this;

Please Login or Register  to view this content.

Thanks your tip led me to investigate...