VBA Offset

[tangmere.milli]

Morning all,

I am looking for a little help with my VBA code. As my knowledge of this is pretty basic, I am unable to make the tweak to this that I require.

The code below allows me to insert pictures into an Excel spreadsheet. The first part of the code enters pictures into column AA, and the second into column AB. In each column, there will be multiple images that will insert in rows 2,3,4,5,6 etc.

What I need to do is get the code to skip 6 rows for each image that it needs to enter (i.e. AA2, AA8, AA14, AA20 etc.)

Please Login or Register  to view this content.

I would imagine that this would be a relatively simple thing to do if you know VBA. Any help would be greatly appreciated.

TM.

[StephenR]

Maybe this for the first bit - have added the variable r - so perhaps you can adapt for the second bit?

Please Login or Register  to view this content.

[tangmere.milli]

Brilliant Stephen! This does exactly what I wanted it to do!!

Would you be able to show me the VBA code to convert an individual workbook to pdf and then open up a new email within Outlook and attach this pdf document?

[StephenR]

Glad to hear it. That sounds like a separate question so I suggest you start a new thread, and link to this if necessary.

[tangmere.milli]

Fair enough, thanks for your help!