Thanks; I'm going to go back and do it the way you suggested, but I played
with it last night and deleted the first two lines. After that, the code ran
well enough for me to tailor results. But I want to get it running the way it
should with the Attribute statements included.

Thank you for your help! You guys motivate me to keep learning the code.
--
FirstVette52


"Chip Pearson" wrote:

You need to Import the bas file, not copy/paste out of Notepad.
Attribute statements are compiler directives that VBA uses but are not
entered directly in the module. In VBA, go to the File menu, choose
Import File, navigate to where you saved the bas file, and open it. It
will create a module named modFindAll in your project.

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)


On Thu, 19 Feb 2009 14:03:02 -0800, FirstVette52 <(My User name is
Firstvette 52, too) firstvet52@(my ISP E-mail provider is)
netzero.com wrote:

OK I copied and pasted your Function 'FindAllOnWorksheets' into a new Module,
but executing the code gave me an 'Undefined' error for the 'Attribute
VB_Name...' code at the very beginning (sorry, I'm not too good at this).