Canders_12
asked on
Picture & VBA fun Fun FUn FUN :)
Hello all,
I have a picture on a worksheet of a lego head labelled "lego_head". I would like to select a range of cells and for all the cells within the chosen selection I would like to paste a copy of the lego head mentioned above. I.e. If I select cells "B2:C4" I would expect to see 6 lego heads (one in each of the 6 cells).
Any help would be greatly appreciated.
I have a picture on a worksheet of a lego head labelled "lego_head". I would like to select a range of cells and for all the cells within the chosen selection I would like to paste a copy of the lego head mentioned above. I.e. If I select cells "B2:C4" I would expect to see 6 lego heads (one in each of the 6 cells).
Any help would be greatly appreciated.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Many thanks to you both, greatly appreciated.
Glad to help. Thanks for jumping in, Saqib.
Thomas
Thomas
ASKER
Many thanks for the swift reply. The only question I have is how easy is it to amend the code so teh range may be variable. "B2:C4" was an example. The user may choose "B2:D5".
I hope this makes sense? Many thanks.