Driving me crazy. I know that I'm close but can't seem to get the syntax right on the 'select' line: ActiveSheet.Range(sChoice).Select
Column #2 should be considered as text as it has values such as "73g"
This process does a search through a range. It works good and picks out the value of the cell as it should. (my MsgBox 'es prove that to me). My problem is that I need my cursor to go to that cell when it is picked, so that the user can see the whole row that is adjacent to it. Here is the code:
Code
Sub SearchBox()
Dim rg As Range
Dim sRes As Variant
Dim sItem As Variant
Dim sChoice As Variant
sItem = Sheets("Search Trial").Range("E1")
MsgBox sItem
Set rg = Sheets("Search Trial").Range("A4:B217")
sRes = Application.VLookup(sItem, rg, 2, True)
sChoice = sRes
MsgBox sChoice
ActiveSheet.Range(sChoice).Select
'Above statement error: Application or Object defined error
MsgBox ActiveCell
End Sub
Display More
Any help will be greatly appreciated
Thanks Jimmy