How to get my code to target only sheets that are named in a specific ranges?

Hi,

I have the following code:

Please Login or Register  to view this content.

Currently i have the section that ignores certain sheets but instead i'd like it to only cycle through a list of necessary sheets that currently resides in a sheet called control in colB between cells 7 and 106. However this list changes each day so there can be blank cells at the end which obviously dont equate to a sheet name. I've tried a few things but nothing seems to work. can anyone point me in the right direction?

Hi John,
there are 2
End If
End If
need to get rid one of them.

@AB33. Good catch. Edited Post.