question

JonathanBrotto-3536 avatar image
0 Votes"
JonathanBrotto-3536 asked

Excel formula to get the quote

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>


dotnet-visual-basicoffice-vba-devoffice-scripts-excel-devoffice-vsto-com-dev
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

0 Answers