Error 1004 Displaying history data
Dear All,
While creating reports using excel and ABB data direct, I receive following error message from Data Direct.
"Error 1004 displaying history data Unable to set the FormulaArray of the Range class".
I am able to get values from other tags only a few tags return this error. Any help please.
BR.
Asked 11 months ago
Answers
1
Problem solved by reducing character length of my array. Excel supports 255 characters array. Either we have to reduce length or split up formula into chunks.
Answered 11 months ago
Add new comment