Getting code to cycle over itself and ignore blank cells

Hi Experts, I previously posted this code but was way off base with it so with helpful advice from another member i was able to clean up the code but i am still struggling to get to the end result.

What I am trying to do is get the code below in section 1 to cycle through a range so that it copies the first cell in the range, creates the three pdf's then goes back to the 2nd cell and repeats until it has completed the range and ignores errors or blank cells withing the range and then ends on section 2.

Please Login or Register  to view this content.

I have a similar code that emails out from a range but i can not seem to manipulate the code to fit new requirements

Please Login or Register  to view this content.

Any input that might help in right direction would be great

Thanks In advance

Wow just wow, thank you - i had to modify my sheet slightly but it worked thank you so much

Thats roughly what I am seeing now as I start to move all the coded button to one sheet the codes stop working and its due to your last comments, so thank you you solved two issues in one thread, how would you suggest the best method of learning code is?