Error 91, Stops at the Find statement.

**Erik345** · 06-14-2011, 03:51 AM

Hi, im trying to acquire the row number of the word "#outputs" though im failing misserably, what am i doing wrong? I Always get the error "Object variable not set (Error 91)"

Please Login or Register  to view this content.

**Colin Legg** · 06-14-2011, 04:08 AM

Hi Erik,

You're getting the error because it can't find a cell containing the word #outputs (it can't activate a cell it hasn't found).

Looking at your code, I can see you putting #Inputs into the new worksheet, but I can't see you putting in #outputs anywhere. Is #outputs on a different sheet?

**snb** · 06-14-2011, 05:18 AM

Did you know ?

Please Login or Register  to view this content.

**Erik345** · 06-14-2011, 05:39 AM

Thank you so much! I was starting to stare myself blind at the code.

**Erik345** · 06-14-2011, 07:58 AM

Can i ask you one more thing?
I've got this for-loop with an If statement inside of it. Though the condition seems to have faulty syntax.

Please Login or Register  to view this content.

**Mordred** · 06-14-2011, 08:18 AM

HI Erik, does Gx, Hx, and so forth represent ranges? If so, declare them like:

Please Login or Register  to view this content.

. I think that is what is wrong.

**Colin Legg** · 06-14-2011, 08:22 AM

Sure...

I'm guessing what you want here, but this is a literal "translation" of your code:

Please Login or Register  to view this content.

If that's not what you want then please can you describe in words what you are trying to do?

Also, are you sure that using Or rather than And is correct?

Or ---> All of the cells in columns H, I, J, K, L must match column G, otherwise you get a message box saying "NUNNA"

And---> Any of the cells in columns H, I, K, K, L can match column G, otherwise you get a message box saying "NUNNA"