Help with VB Code to look in Column and compare it to a set Value

[rv02]

Dear All

I was wondering whther someone can help me with the follwoing code:

I have a worksheet with three columns , Customer, Spend Division

I need to look in the whole of column Division (c and compare it to my set variable which I have set in the code and if its equal to that the store it in another variable.

My code so far is

Please Login or Register  to view this content.

However this doesn't work.

Basically I want to look at the whole of Column C and if any of the cells is equal to Mens then returns the value of the corresponding cell in Col A:.

Any hep is appreciate it

[kev_]

Try this
All variables need the "As String" (or whatever), otherwise only the last one is declared as type "String"
The range you should have declared was "divs" (not "Range")
The code builds up a message string to give you everything listed at the end
If you want an explanation of anything please ask.

Please Login or Register  to view this content.

Kev

[rv02]

Thanks Kev

This worked great

[kev_]

You are welcome.