Skip to content

Instantly share code, notes, and snippets.

@erajanraja24

erajanraja24/Copy image on the same sheet

Created March 13, 2016 13:53
Show Gist options
  • Save erajanraja24/cf241b87916326ae98c6 to your computer and use it in GitHub Desktop.
Save erajanraja24/cf241b87916326ae98c6 to your computer and use it in GitHub Desktop.
Download ZIP
Copy Image from one cell to another cell on the same sheet
Raw
Copy image on the same sheet
Sub copyimage1()
'Activate the sheet 1
ThisWorkbook.Sheets(1).Activate
'Select Range A1
ThisWorkbook.Sheets(1).Range("A1").Select
'Copy the image and all other values
Selection.Copy
'Select the target cell D6
ThisWorkbook.Sheets(1).Range("D6").Select
'Paste the data
ThisWorkbook.Sheets(1).Paste
End Sub
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment