Applying code to entire column

Hi Guys,

I'm pretty new to vba, and i've written some code which works fine apart from i need it to run down an entire column, as it stands it's just one cell.

Here's a section of the code, it is considerably longer but it's pretty much repeating the same format just looking for different data.

Please Login or Register  to view this content.

I've tried a few a couple of ways to apply it to the column but it just seems to crash or error. Any help is hugely appreciated

Maybe

Please Login or Register  to view this content.

You should read the forum rules and add code tags to your code extract.

However, just to make you welcome ...

Untested code:

Please Login or Register  to view this content.