Bernie,
I knew that wasn't the problem - which is why I emphasized that the code
worked fine for me - nonetheless, what I stated as a problem is a problem
once the OP gets it working with his layout as described - easily rectified.
So when I say it worked fine for me, I needed to tell the whole story.

--
Regards,
Tom Ogilvy

"Bernie Deitrick" <deitbe @ consumer dot org wrote in message
...
Tom,

The lack of headers wasn't his problem. He copied the code through web
access, and the code in the workbook that he sent me had a few dashes
sprinkled throughout. That is something that I have seen recently when
copying code out of the Google archives, but haven't experienced with
active
messages. I guess it is something that we will need to start warning
about.

Bernie


"Tom Ogilvy" wrote in message
...
It worked for me with his posted data, but if Cat is in A1 as he stated,
it
causes a slight problem in the results.

All the Data functions like a header in row 1.

--
Regards,
Tom Ogilvy


"Bernie Deitrick" <deitbe @ consumer dot org wrote in message
...
I can't get your error: make sure that none of the lines have been
broken
into two lines by your
news reader - look for lines in red (typically) once you paste them
into
your codemodule.

If that doesn't work, send me your workbook, and I will take a look and
get it working. Reply to me,
then take out the spaces and change the dot to . in my email address.

HTH,
Bernie
MS Excel MVP


wrote in message
oups.com...
I am getting a Compile Error / Syntax error. Any other thoughts?
Thanks

The very top left entry A1 is Cat.

Cat 5 1
Dog 4 2
Dog 4 3
Cat 5 4