Compare/match positve number against negative number?
 

Thanks, but was hoping for a little bit more detail

--
Kobayash
-----------------------------------------------------------------------
Kobayashi's Profile: http://www.excelforum.com/member.php...info&userid=87
View this thread: http://www.excelforum.com/showthread.php?threadid=31488

Compare/match positve number against negative number?
 

Any ideas? Anyone? Seems that a worksheet function within my code wil
be the way to go (for speed) but I could do with some help with th
'how'?

Thanks,

Adria

--
Kobayash
-----------------------------------------------------------------------
Kobayashi's Profile: http://www.excelforum.com/member.php...info&userid=87
View this thread: http://www.excelforum.com/showthread.php?threadid=31488

Compare/match positve number against negative number?
 

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)


On Fri, 19 Nov 2004 09:39:15 -0600, Kobayashi
wrote:


Any ideas? Anyone? Seems that a worksheet function within my code will
be the way to go (for speed) but I could do with some help with the
'how'?

Thanks,

Adrian