Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unable to set the FormulaArray property in Excel 97
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 -- There are 10 types of people in the world - those who understand binary and those who don't. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Unable to set DisplayAlerts property | Excel Programming | |||
Unable to set FormulaArray property of the Range class | Excel Programming | |||
unable to set the FormulaArray property of the Range class | Excel Programming | |||
Unable to get VLOOKUP property | Excel Programming | |||
unable to set formulaarray of range class ERROR when using Conditional Sum | Excel Programming |