Dim Target As Double
Dim Rng AS Range
Dim Where AS Long
Target = 23
Set Rng = Worksheets("Sheet1").Range("A1:A100")
Where = Application.Match(-Target, Rng, 0)
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.