Difference between revisions of "Error Messages/41142"
AManandhar (talk | contribs) |
|||
Line 1: | Line 1: | ||
− | + | [[Category: Error messages]] | |
− | + | == Error message examples == | |
− | + | :<code>''When calling function SpreadsheetRange, the indicated named cell range, 'Losses', was not found.''</code> | |
− | + | == Cause == | |
− | = Remedies = | + | You have passed to [[SpreadsheetRange]] a range-name that does not exist in the passed worksheet. |
+ | |||
+ | == Remedies == | ||
If the range has already been defined, open the spreadsheet and verify the range name, and then correct the function call accordingly. | If the range has already been defined, open the spreadsheet and verify the range name, and then correct the function call accordingly. | ||
Line 13: | Line 15: | ||
If the range has not been defined yet, open the spreadsheet and define the range, and then correct the function call with the newly defined range name. | If the range has not been defined yet, open the spreadsheet and define the range, and then correct the function call with the newly defined range name. | ||
− | + | ==See Also== | |
+ | * [[SpreadsheetRange]] | ||
+ | * [[Read and Write Spreadsheets ]] | ||
+ | * [[Read from and write to Excel spreadsheets]] | ||
+ | * [[Functions To Read Excel Worksheets]] | ||
+ | * [[Functions to Write Data to Excel Worksheets]] | ||
+ | * [[Excel to Analytica Mappings]] | ||
+ | * [[Excel to Analytica Translation]] |
Revision as of 21:14, 22 February 2016
Error message examples
When calling function SpreadsheetRange, the indicated named cell range, 'Losses', was not found.
Cause
You have passed to SpreadsheetRange a range-name that does not exist in the passed worksheet.
Remedies
If the range has already been defined, open the spreadsheet and verify the range name, and then correct the function call accordingly.
If the range has not been defined yet, open the spreadsheet and define the range, and then correct the function call with the newly defined range name.
See Also
Comments
Enable comment auto-refresher