MACRO, ERROR 1004, Method 'Range' of object '_Global' failed

i am trying to loop through a column of one worksheet, and look to see if the values have already been incuded in the columns of another worksheet. Basically i need to include any values that may have been missed, and ignore values that have been repeated.

What i have tried to do is 'for' through the first list and check how many times a specific word comes up with reference to another list.

if it doesnt show up i am trying to make it write its name in the next empty box.

Analyzer class A
Analyzer class A
Analyzer class d
ALARM class A
Then in myy spreadsheet
Im going to have

A B C D
Analyzer 2 0 0 1
Alarm 0 0 0 1

That is basically what i want to end up with

Here is my code i get a 1004 error when i am trying to define the specific cell Ranges, it says that the range is hidden. I have identified where the error occurs can somebody please help me out

Please Login or Register  to view this content.

Hi,
first could you edit your post by putting code tags round the code [code ] at the beginning and [/code ] at the end (but without the spaces).

From the way you have described your requirement I think this could be done just with worksheet functions. Could you attach a sample spreadsheet it is easier to see what is going on.

Hello ssbhardw,

Welcome to the Forum!

There are some rules you need to be aware of when you post.
1. Your thread title should clearly describe your problem or question.
2. To make the code easier to read and copy, format it with Code Tags.

Because you are new, I have wrapped the code for you.

As a new member, please take some time to familiarize yourself with the rules.
Forum Rules

Hi ssbhardw

I believe Mr Ross also asked you to change your thread title. If you'll do that, I've got some suggestions for your issue.

John