naresh_ank
New Member
- Joined
- Nov 20, 2020
- Messages
- 2
- Office Version
- 365
- Platform
- Windows
Hello Forum Group,
Grettingss...
Iam using below code to insert the Images in the Excel sheet ...
NewFN = "C:\Users\ankat\OneDrive\Pictures\Screen-Shots\Testcase1.jpg"
ActiveSheet.Shapes.AddPicture(Filename:=NewFN, _
LinkToFile:=msoFalse, _
SaveWithDocument:=msoTrue, _
Left:=1, Top:=1, Width:=140, Height:=195).Select
Here myself facing difficuly to insert the Image at Exact cell location,iam using Left and Top corredinates but if any body changes cell high then the corredinates are chageing and image is moving to other areas...
My self used "Range("A86").Select" , "ActiveCell.Select " but iam unable place the Image at this cell...
Please suggest the method to insert the Image @ cell loaction in the Excel sheet
Thanks
Please suggest how i can use
Grettingss...
Iam using below code to insert the Images in the Excel sheet ...
NewFN = "C:\Users\ankat\OneDrive\Pictures\Screen-Shots\Testcase1.jpg"
ActiveSheet.Shapes.AddPicture(Filename:=NewFN, _
LinkToFile:=msoFalse, _
SaveWithDocument:=msoTrue, _
Left:=1, Top:=1, Width:=140, Height:=195).Select
Here myself facing difficuly to insert the Image at Exact cell location,iam using Left and Top corredinates but if any body changes cell high then the corredinates are chageing and image is moving to other areas...
My self used "Range("A86").Select" , "ActiveCell.Select " but iam unable place the Image at this cell...
Please suggest the method to insert the Image @ cell loaction in the Excel sheet
Thanks
Please suggest how i can use