Inserting image in a particular cell in VBA
Solved/Closed
Hello All,
I wanna insert an image into the Activecell but the image is getting inserted into the same default area. Kindly help me regarding this by checking the code below
Sub pics()
Range("Q1").Activate
ActiveSheet.Pictures.Insert ("E:\personal\adi.jpg")
End Sub
I wanna insert an image into the Activecell but the image is getting inserted into the same default area. Kindly help me regarding this by checking the code below
Sub pics()
Range("Q1").Activate
ActiveSheet.Pictures.Insert ("E:\personal\adi.jpg")
End Sub
Related:
- Excel vba insert picture from folder
- Anvi folder locker reset key - Guide
- Insert gif in excel - Guide
- Excel vba create folder if not exist ✓ - Excel Forum
- How to insert picture in word without moving text - Guide
- Number to words in excel formula without vba - Guide
3 responses
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Nov 1, 2016 at 11:27 AM
Nov 1, 2016 at 11:27 AM
Hi adikademani,
To place the image in the active cell instead of Q1 then replace:
Range("Q1").Activate
By:
ActiveCell.Activate
Best regards,
Trowa
To place the image in the active cell instead of Q1 then replace:
Range("Q1").Activate
By:
ActiveCell.Activate
Best regards,
Trowa