Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() I don't really understand your post, Don. Is what you're saying that should write my code as follows (without the = sign inside the quote for my string assignment)? Code ------------------- Dim ReportD As String ReportD = "=IF(ISNA(MATCH(R[0]C[-2],PID!B:B,0))=FALSE, ""x"","""")" Worksheets("Report").Range("D5").Offset(counter, 0).Formula = Report ------------------- This just seems to put the string in the cells as text and no formulas. Thanks, To -- ob3ron0 ----------------------------------------------------------------------- ob3ron02's Profile: http://www.excelforum.com/member.php...fo&userid=1545 View this thread: http://www.excelforum.com/showthread.php?threadid=27047 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Formula result does not match displayed result | Excel Worksheet Functions | |||
Formula Bar F9 Result differs from cell 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 |