Help with creating a loop within vba

Hi All

Could anyone advise on how to turn the following code into a loop? I need this to check through columns B to BK, i have the code working by duplicating the code for each column, but this seems very messy and very long!

Please Login or Register  to view this content.

Any help would be appreciated.

Thanks

Perhaps a macro like this?

Please Login or Register  to view this content.

Alf

that worked great - many thanks

Glad to be of help. Thanks for rep and feed back!

Alf