Searching Including Hidden rows

Dear All,

Please see below my code which looks at two ranges find initials beginning with a % and lists them in a userform. The code works fine except if the rows are hidden it does not pickup the value. Is there a parameter i can change or add?

Please Login or Register  to view this content.

Thank you as suggested changed xlValue to xlFormula and works a treat. Thank you