Hi All,

I am a bit new to this VBA business and am struggling to get a piece o
code right.

I wish to search all of column B for a user inputted variabl
"Lookup_in" and then for that cell to be selected

I have been trying:-

Public Sub Display_Temp()

Dim Lookup_ref

Range("a1").select

Lookup_in = Inputbox("Record to Look up?", "Project Log Lookup", 63
1)

Lookup_ref = Worksheets("Project Lo
Form").Range("B8:B10000").Find(Lookup_in)

Range(Lookup_ref).select

End Sub

The program gets stuck on the last line, which I find confusing as i
successfully finds the Lookup_in variable, just will not recognise i
as a cell address in order to locate it.

Any help would be very gratefully received.

Thanks alot

And

--
Message posted from http://www.ExcelForum.com