Hi,
I have a big piece of code that inserts pictures into a template using an URL, now sometimes it works and then somehow offsets itself upon the next run and I'm unsure why.
This is the code simplified but on the line of..
It doesn't paste directly into the top left as it should? It pastes a little offset down and to the right..
Full simplified code.
Any help?
** UPDATE **
When I create a copy of the sheet, it fixes it on the next sheet and looks exactly how it should do, can't understand why? But on the original sheet, when I changed the zoom from what it was it auto-corrects itself, so is this a graphical bug as even printing is perfect, it's just on screen it looks messed up.
Thanks,
I have a big piece of code that inserts pictures into a template using an URL, now sometimes it works and then somehow offsets itself upon the next run and I'm unsure why.
This is the code simplified but on the line of..
Code:
Set Pic = .Parent.Pictures.Insert(URL)
It doesn't paste directly into the top left as it should? It pastes a little offset down and to the right..
Full simplified code.
Code:
Sub Test()
URL = "http://media.topshop.com/wcsstore/TopShop/images/catalog/TS01G08NBLK_Large_F_1.jpg"
Set PicPosition = template.Cells(5, 3)
With PicPosition
.Select
Set Pic = .Parent.Pictures.Insert(URL)
With Pic
.Top = Pic.Top + 8.7
.Left = Pic.Left + 26.1
.Width = 92.6929242
.Height = 100.629933
End With
End With
Set Pic = Nothing
End Sub
Any help?
** UPDATE **
When I create a copy of the sheet, it fixes it on the next sheet and looks exactly how it should do, can't understand why? But on the original sheet, when I changed the zoom from what it was it auto-corrects itself, so is this a graphical bug as even printing is perfect, it's just on screen it looks messed up.
Thanks,