Find within a range give different variables

[jnh0]

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]

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

[HaHoBe]

Hi, jinho,

maybe like this:

Please Login or Register  to view this content.

Ciao,
Holger

[jnh0]

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

Inside that range I need to find the Cp's

[HaHoBe]

Hi, jnh0,

Please Login or Register  to view this content.

Ciao,
Holger

[jnh0]

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

Please Login or Register  to view this content.

[jnh0]

Can you tell me what Im doing wrong here:

Please Login or Register  to view this content.

is somethig wrong with "findcount"