MikeBlake
05-12-2009, 07:52 AM
Hi there,
This is my first post on this site. Had some trouble with this issue for a while so any help would be greatly appreciated.
The problem is that I am using PasteSpecial function in VBA Excel to paste a shape (e.g. picture 27) from 1 sheet to another in the same workbook. I then need to clear all data in the 2nd sheet including deleting the pasted shape. Problem is that when the shape / picture gets pasted into the destination sheet it's name changes e.g. from picture 27 to picture picture 14 for example. Therefore I can't refer to it again so I can delete it automatically using another command button.
Set NokiaE66 = Sheets("Voda GP").Shapes("Group 38")
Dim AH As String
AH = Application.InputBox(prompt:="Enter model of handset to display:", Type:=2)
If InStr(AH, "E66") Then
NokiaE66.Copy
Sheets("VodaQuote").Range("B70").PasteSpecial
End If
How can I find out what the newley pasted shape object is automatically called inside the destination sheet?
Many thanks,
Mike
This is my first post on this site. Had some trouble with this issue for a while so any help would be greatly appreciated.
The problem is that I am using PasteSpecial function in VBA Excel to paste a shape (e.g. picture 27) from 1 sheet to another in the same workbook. I then need to clear all data in the 2nd sheet including deleting the pasted shape. Problem is that when the shape / picture gets pasted into the destination sheet it's name changes e.g. from picture 27 to picture picture 14 for example. Therefore I can't refer to it again so I can delete it automatically using another command button.
Set NokiaE66 = Sheets("Voda GP").Shapes("Group 38")
Dim AH As String
AH = Application.InputBox(prompt:="Enter model of handset to display:", Type:=2)
If InStr(AH, "E66") Then
NokiaE66.Copy
Sheets("VodaQuote").Range("B70").PasteSpecial
End If
How can I find out what the newley pasted shape object is automatically called inside the destination sheet?
Many thanks,
Mike