Looping through worksheets defined in named range

[boon-yao.tek]

This is a really simple question, but I can't seem to find any solution from any forums. Or I might be searching on wrong keywords.

I have a number of sheets in the workbook

Let say,

Sheet names
Chapter 1
Chapter 2
Chapter 3
Synopsis
Summary

I have set a named range ("SheetsToChk") that refers to cell that I have entered the names of the sheets I want the macro to loop through.
For e.g:
Chapter 1
Chapter 2
Chapter 3


I have also tried the code below, but the Macro just don't go to any other sheets. Please advise me how I can do a loop through worksheets that I have specify in the named range that I have set?

Please Login or Register  to view this content.

[humdingaling]

try this loop

Please Login or Register  to view this content.

i used msgbox because i dont have mycode

[boon-yao.tek]

is it possible to refer to the named range set instead of checking if sheets' name start with Chapter?

as it does not always start with chapter...

[humdingaling]

Please Login or Register  to view this content.

variation based on (named) range
wsl to your named range

however you need to define what your checking against ultimately

[boon-yao.tek]

I just want to go through each of the worksheet specified in the named range let say ("sh_pull")
and execute my code in each of those sheet.

I don't want the check value that starts with "chapter"...

i tried to just put

Please Login or Register  to view this content.

but fails. it kept saying i have mismatch

[humdingaling]

then just take out the if statement on post #4

[boon-yao.tek]

i tried but still doesn't work.

I have attached the sample i'm working on.
loopthrusheets.xlsm

when i run the macro, it only put the word "title" on the sheetname "master" instead of what I have defined in the name range "sh_chk" for chapter 1,2 and 3.

[humdingaling]

you took out too much of the code
see attached

Run macro Chk2

[boon-yao.tek]

thanks so much, it finally works!

could you explain what is the 'replace' for?

Please Login or Register  to view this content.

[humdingaling]

the value it takes comes with " " around the sheet name
ie "Chapter 3"
replace is to remove the "

[boon-yao.tek]

Thanks alot, appreciate your guidance.

[humdingaling]

sure thing
not a problem
thanks for the rep