| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sumproduct with double quoted strings
Hello,
I have procedure that reads strings from a file LayerC = Chr(34) & Layer & Chr(34) Then Evaluate a count CountIn = _ xlApp.Evaluate("SUMPRODUCT((" & _ MainDataRange.Address & "=" & TvahC & ")*(" & RangeLayers.Address & "=" & LayerC & "))") The problem is if the variable Layer contains double quotes (For Example N"Y) , the new variable LayerC is now "N"Y", which the 2nd statement does not accept Any idea? Thanks Avi |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sumproduct with multiple criteria and both numbers and strings | Excel Discussion (Misc queries) | |||
| Double quotes bracketing text strings that include commas | Excel Discussion (Misc queries) | |||
| recognizing double digit numbers in strings | Excel Programming | |||
| SUMPRODUCT- double unary vs. * | Excel Worksheet Functions | |||
| Sumproduct and finding partial strings | Excel Programming | |||
Threaded Mode
