• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

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
 

mohadin

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.
 
Top