My equation is too long!
Thanks Tom,
The equation is only 181 characters long if I count correctly (within the
quotation marks). Is there a column width limitation in VBA editor? The
equation stretches out into column 192 right now. And if so, where could I
insert the " _" continuation mark to make it continue onto the next line.
"Tom Ogilvy" wrote:
for FormulaArray property, I believe the limit is 255 characters. Manually,
the limit is 1024 characters.
--
Regards,
Tom Ogilvy
"OkieViking" wrote in message
...
I am populating a table with equations. However, some of them are too
long.
I can type them in manually (and they work), so I know the equation is OK.
What can I do?
Selection.FormulaArray = _
"=SUM(IF(('DIMS Data (2)'!R1C1:R6992C[-2]=""MAG DEV TLP RIG
MOB"")*('DIMS Data (2)'!R1C8:R6992C[5]=" & PN & ")*('DIMS Data
(2)'!$I$1:$I$6992='RISER'),'DIMS Data (2)'!R1C6:R6992C[3]))"
That is only two lines of code
|