Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Formula Result Different Than Manual Formula Result
Thanks for the reply! When you say I've mixed R1C1 with A1, where do you mean? With th .offset() property? I can't see how to get around using the .offset( property... oh and I tried using the .formulaR1C1 property but it yielded the sam results. also note the edit i made at the bottom of my previous pos -- ob3ron0 ----------------------------------------------------------------------- ob3ron02's Profile: http://www.excelforum.com/member.php...fo&userid=1545 View this thread: http://www.excelforum.com/showthread.php?threadid=27047 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Formula Result Different Than Manual Formula Result
Dim ReportD as String
ReportD = "=IF(ISNA(MATCH(RC[-2],PID!C2,0))=FALSE,""x"","""")" Worksheets("Report").Range("D5").Offset(counter, 0).FormulaR1C1 = ReportD C2 in the above means Column B (2nd column in the worksheet PID) -- Regards, Tom Ogilvy "ob3ron02" wrote in message ... Thanks for the reply! When you say I've mixed R1C1 with A1, where do you mean? With the offset() property? I can't see how to get around using the .offset() property... oh and I tried using the .formulaR1C1 property but it yielded the same results. also note the edit i made at the bottom of my previous post -- ob3ron02 ------------------------------------------------------------------------ ob3ron02's Profile: http://www.excelforum.com/member.php...o&userid=15450 View this thread: http://www.excelforum.com/showthread...hreadid=270473 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula result does not match displayed result | Excel Worksheet Functions | |||
Advanced formula - Return result & Show Cell Reference of result | Excel Worksheet Functions | |||
Median result used in formula gives incorrect result | Excel Worksheet Functions | |||
VBA Formula Result Different Than Manual Formula Result | Excel Programming | |||
VBA Formula Result Different Than Manual Formula Result | Excel Programming |