Kevanova
New Member
- Joined
- Dec 13, 2013
- Messages
- 34
Hi
I've got the following code to paste a shape into a Range.
The problem is the cell is a a merge of Z6:AA11 and I can't change this. Is there any way to paste it into the centre of this range?
Thanks
Kevin
I've got the following code to paste a shape into a Range.
Code:
ActiveSheet.Shapes("Picture").Copy
Application.Goto Concerns.Range("Z6")
ActiveSheet.Paste
The problem is the cell is a a merge of Z6:AA11 and I can't change this. Is there any way to paste it into the centre of this range?
Thanks
Kevin