Find within a range give different variables

**jnh0** · 08-18-2013, 03:32 AM

Hello everyone!!

Im trying to find 4 variables:

Please Login or Register  to view this content.

In this given range:

Please Login or Register  to view this content.

If it doesnt find non of them, the macro should close the sheet

Can you help me? Thanks!!

**patel45** · 08-18-2013, 03:42 AM

you are searching "Resp. Co" (not your variables) in the whole Sheet, non in a range.

**HaHoBe** · 08-18-2013, 03:44 AM

Hi, jinho,

maybe like this:

Please Login or Register  to view this content.

Ciao,
Holger

**jnh0** · 08-18-2013, 03:51 AM

Yes Im searching for "Resp. Co" to be able to set a range.

Inside that range I need to find the Cp's

**HaHoBe** · 08-18-2013, 03:57 AM

Hi, jnh0,

Please Login or Register  to view this content.

Ciao,
Holger

**jnh0** · 08-18-2013, 04:06 AM

Something like this is what I need, but its something wrong with "findcp".

Please Login or Register  to view this content.

**jnh0** · 08-18-2013, 04:20 AM

Can you tell me what Im doing wrong here:

Please Login or Register  to view this content.

is somethig wrong with "findcount"

Re: Find within a range give different variables