adjusting a picture size and pasting it to selected range in otherworkbook
<p>This might to be too easy to ask but i am a beginner.</p>

<p>I want to be able to copy ranges from a worksheet and paste it to another worksheet in adjusted size which i should pick and paste it to selected range area in the otherworksheet.</p>

<p>When i do this by using a macro, i can paste it and adjust its size manually.When i try to use this recoreded macro again, it does not paste it to the range that i have selected and its size is not like its original nor like my adjusted size.</p>

<p>How can i specify the size and the ranges the paste?</p>