Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Converting Negative Number to Postive number | Excel Worksheet Functions | |||
Can I automatically change all positve numbers to negative number. | Excel Discussion (Misc queries) | |||
2003= negative number&2004= negative number How Do I Calculate gro | Excel Worksheet Functions | |||
calculate negative or positve difference in time | Excel Discussion (Misc queries) | |||
Compare/match positve number against negative number? | Excel Programming |