Excel formula to get the quote

Jonathan Brotto 1,076 Reputation points
2022-01-17T21:45:18.933+00:00

Trying to double quote around the date field in my excel formula string, but get an error message 

        customerYearRng.Value2 = "=SUMIFS('Raw SAP'!$O:$O,'Raw SAP'!$D:$D, "" */*/ " & "$B$2" & ",'Raw SAP'!$L:$L,'Product Summary'!A3)"

System.Runtime.InteropServices.COMException
HResult=0x800A03EC
Message=Exception from HRESULT: 0x800A03EC
Source=<Cannot evaluate the exception source>
StackTrace:
<Cannot evaluate the exception stack trace>

VB
VB
An object-oriented programming language developed by Microsoft that is implemented on the .NET Framework. Previously known as Visual Basic .NET.
2,580 questions
Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,532 questions
0 comments