for each with cell content in formula

[wildonln]

i need to use a for each to check the content in range B25:B49.
the content is sheet names visible

for each visible sheet name i cells B25:B49 i need to use the name in a formula reference in range G25:G49.

the B25:B40 range is getting the sheet name correct in the formula.

So if B25 have content the formula in G25 should be something like

Please Login or Register  to view this content.

then check next cell, B26 ..

thanks for any help.

[wildonln]

the "w550" reference will always be the same for every sheet.

[wildonln]

anyone who could help me ?

[StuCram]

Try This:

Please Login or Register  to view this content.

[wildonln]

Hi StuCram.

i edited your code with an if statement so if there is no name in designated cell for sheet names the sub ends.

Please Login or Register  to view this content.

i appreciate your help. Thanks.