Help with filling into merge cells into a loop

[1912dummy]

Hello,

I like to fillout on sheet2 the values on sheet3
on the columns A2 andalso F2 till down page of all the A and F
i tried to fill them all in from the values on sheet3
but its not working it don't fill F and skip some lines or even values

can someone helpme out

Thanks

[oeldere]

Maybe because of the merged cells.

For other forummembers.

In the file of 1912dummy is the following code.

Please Login or Register  to view this content.

[jindon]

What is your desired result?

[1912dummy]

Hello,

Well something like this
i readded the sample file again
i making cards to print out but need to fill them with data
and the we create the image on A2

that also need to added from the loop aswell

[torachan]

Merged cells - designed by the 'Devil' to frustrate all Excel users.
Simple advice - do not use them - read up on the reasons not too.
Look at your code and see what is happening - 'Test1' into cell A2 - 'Test11' into cell A12
The merged cell is simply masking rows 3 to 11 - unmerge your A2 merge - then run your code - there is your answer.
torachan.

[1912dummy]

Hello torachan,

yep it comes all on A
so how can i avoid that
so it will fill my cells i need?
and yeah but i need the merge cells because there will the picture placed on

[jindon]

Like this?

Please Login or Register  to view this content.

[1912dummy]

that is so amazing jindon
just wow
Thank you

so then i use the same way for adding the images ?
from the values on A and F

this is the code i will use for making the images

Please Login or Register  to view this content.

or we use an other way to fill the A2

[jindon]

Your question was to find the cell reference in Sheet2, so as long as the sheet layouts are the same, it should do.

[1912dummy]

Okay thank you
all for the great help
now i can continue for a little while

Thanks

[sintek]

Please Login or Register  to view this content.

[1912dummy]

Hello sintek

thank you for the sample

going to look into it

[1912dummy]

Sorry but still have a question
how do i selected all the cells
that are filled

so i can selected the whole card
so for example the card from A1 till J11
and so on

Thank you

[jindon]

Why do you need to Select the range?

Please Login or Register  to view this content.

[1912dummy]

i need to printout only where the cells are filled with the data from sheet3
and not empty ones

[jindon]

Please Login or Register  to view this content.

[1912dummy]

thank you jindon
works like a charm