Creating a copy, paste, print Loop VBA

[evian123]

Hi,

I am trying to create a macro that will cycle through cells and print certain ranges dependant upon vlookups, it is essentially a primative certificate generator as im not much use with excel

So far i have this code:

Please Login or Register  to view this content.

I butchered some i found on the internet and inserted my copy and if statements; not sure why its not working!

Any help appreciated!

Thanks,

James,

[patel45]

very confused code, attach please a sample file with data and desired result

[evian123]

I can imagine! im not very experienced with macros!

please find an attached file...

The desired result is that the code cycles through the tags, populates the certificates and prints them accordingly. I already have a macro that does this for 10 as an example, but really i need it to cycle through 100s!

Thanks,

James,

[HaHoBe]

Hi, James,

maybe proceed like this:

Please Login or Register  to view this content.

And if you want to loop through the cells for a check if to print:

Please Login or Register  to view this content.

Ciao,
Holger

[evian123]

Thanks so much!!!!