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 3 years 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 3 years ago
Add new comment