Ignoring Blank Cells

Hi all,

I am hoping someone will be able to help me with this.

I currently have some VBA code which is importing images from a certain cell and displaying them in another tab. This is working well and the images are displaying in the correct cells. However, if the reference cell contains no data (blank, but with a formula in column Y), then the formula offsets and the images are placed further down the list which I am trying to avoid. This is the code;

Please Login or Register  to view this content.

The images are displaying in the correct column (AA & AB), but leave some rows blank if the reference cells contain no data. How can I ignore these blank rows?

Any help would be greatly appreciated.

Many thanks,

TM

hi TM, check if this helps:

Please Login or Register  to view this content.

Thanks watersev, that has resolved part of the issue.

The problem I have now is that the picture are still offset by 2 rows & 2 columns, so the images are inserting 2 rows lower than I require (the column position is correct).

Is there any way round this?

Many thanks,

TM.

if I do not miss anything, try this

Please Login or Register  to view this content.

I don't think I made myself very clear, sorry.

It is only the top image that is offset by 2 rows. Every image that the code retrieves after this is fine (r = r + 6). Just the first image is an issue.

TM

Please Login or Register  to view this content.