Unable to set the FormulaArray property in Excel 97

G

Geoff

The following line for some reason works fine in Excel 2003 but generates a
run-time error '1004' in Excel 97:

View.FormulaArray = "=transpose(" & ratesRng & "1)"

(View is a range, and ratesRng is a string containing the name of a range.)

I am aware of the problem with using a FormulaArray string longer than 255
characters, but this is well short of that with the name of the range
substituted in. Is there any other reason people know of that could cause
this to fall over? More importantly, can anyone suggest a workaround for this
issue, as I am fairly sure a number of users will be opening this in Excel
97...

TIA
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dates In Excel 5
Error 1004 - unable to set the FormulaArray property of the Range 6
FormulaArray limits? 1
FormulaArray in Excel 2007 1
Integrating information from Word to Excel (not mail merge) 1
setting FormulaArray slows down my code 5
Range headings 0
FormulaArray problem 3

Top