Check reoccurring RangeName value in a workbook

[plans]

Hello,
I have a workbook with multiple worksheets.

Many of the worksheets contain a range, named "PlaceHolder".
I am looking for a macro to search through all the worksheets, find the range("PlaceHolder").value.
When it comes across a value <> 0 than display a message like "Place Holders must be ZERO" and end the routine.

I know how to do it using something like :"For Each ws in Worksheets |search if range exists| check value|Next ws", but this can slow down the process when I have a lot of worksheets.
I am wondering if there is a quicker way to do this.

Could you please advise?
Thanks

[mikerickson]

Please Login or Register  to view this content.

[plans]

Thank you mikerikson, it works!