go to vlookup location

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

in column A i have all unique values increasing in value (receipt numbers)
in C1 i have a vlookup value that will give a receipt number
i need to go to the cell in column A that is equal to C1

Thanks in Advance
 
Public Sub Test()
Sheets("Sheet1").Range("A:A").Find
What:=Sheets("Sheet1").Range("C1").Value
End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Code works on sheet but not from code-to-sheet 2
Vlookup result in a message box 10
Compare values in a column 4
Vlookup Function 1
vlookup error 3
simple code but it doesn't look like usual vba code 2
Conditionally count unique values 2
Sheet to sheet code Type Mismatch 6

Back
Top