Importing Pictures From Directory Unaligning The Further It Loops

[Lewzerrrr]

Hi all,

I have a piece of code that imports pictures from my directory in columns of 10 by X rows. For every row imported it seems to shift down by a pixel, overtime this starts to notice if I was to run it for a 1000 row, it would be shifted further down than what it should be.

Now I can't for the life of me understand why as I'm not sure how to skip loop iterations through F8 to understand what it's doing. Here's the following full code:

Please Login or Register  to view this content.

I think it's something to do with this line of code but unsure why it would come out of sync?

Any help would be greatly appreciated!

Please Login or Register  to view this content.

OR if anyone knows how to test if all shapes in a worksheet = incrementleft 26.1 incrementtop 8.7, if not then re-adjust?

What I do at the moment is F5 Objects, Cut and Copy it back into first cell, however this pastes as one picture now instead of multiple so I have to drag across and down?

[alansidman]

crosspost: https://www.ozgrid.com/forum/forum/h...rther-it-loops

Your post does not comply with Rule 8 of our Forum RULES. Do not crosspost your question on multiple forums without including links here to the other threads on other forums.

Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

Expect cross-posted questions without a link to be closed and a message will be posted by the moderator explaining why. We are here to help so help us to help you!

Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).