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
thanks for the quick reply, but the image is still not getting inserted into that particular cell. For example, how do i insert a picture into the Cell Q1 ?
adikademani
>
TrowaD2433
Posts Sunday September 12, 2010Registration dateModeratorStatus
September 17, 2018
Last seen -Nov 2, 2016 at 06:22 AM
Hi Trowa,
Thanks a lott, the issue is solved.
I need some more help with the following. I am trying to insert an image into a particular cell by calling the value stored in the variable via an InputBox. The following code is showing error. Kindly help me. Thank u :)
Sub image()
Dim x As String
x = InputBox("insert image name")
Range("E5").Select
ActiveSheet.Pictures.Insert( _
"G:\PEP\04.Kaizen\KAIZEN Audit\02 Auditfragebögen\5S questionaire\ x "). _
Select
You included the x within the path string. Since it is a variable you need to place it outside like:
"G:\PEP\04.Kaizen\KAIZEN Audit\02 Auditfragebögen\5S questionaire\" & x)
Also make sure that you enter the full file name (so with extention) when prompted by the inputbox for the code you created.
Best regards,
Trowa
Monday, Tuesday and Thursday are usually the days I'll respond. Bear this in mind when awaiting a reply.
