# Find a value only in the first column af a named range?..

#### alexsunny123

##### New Member
Hello,

Do some people can help me to solve the following VBA problem?

In a worksheet I have a set of three named ranges each of three columns (thus nine columns).

I try to find a VBA solution to find a specific value in the FIRST column of one of the three named range.

Example

Range1 = columns A, B, C

Range2 = columns D, E, F

Range3 = columns G, H, I

The value I want to find is e.g. in Range2, column D but also in column F. Only the value found in column D interests me.

thanks
alexsunny

##### Member
Hi
Code:
``````Sub test()
x = InputBox("input seach")
Set res = Range("Range1").Resize(, 1).Find(What:=x, LookAt:=xlPart)
MsgBox x & " found in cell " & res.Column & ":" & res.Row
End Sub``````
Might this gives you an idea

#### alexsunny123

##### New Member
Hello,

Do some people can help me to solve the following VBA problem?

In a worksheet I have a set of three named ranges each of three columns (thus nine columns).
https://ometv.onl https://chatroulette.top https://omegle.wtf https://bazoocam.cam
I try to find a VBA solution to find a specific value in the FIRST column of one of the three named range.

Example

Range1 = columns A, B, C

Range2 = columns D, E, F

Range3 = columns G, H, I

The value I want to find is e.g. in Range2, column D but also in column F. Only the value found in column D interests me.

thanks
alexsunny
thanks my issue has been fixed.