Difference between revisions of "Error Messages/41142"
AManandhar (talk | contribs) (Created page with '= Error Message Examples = When calling function Spreadsheetrange, the indicated named cell range, 'Losses', was not found. = Cause = You have passed a Excel-range-name that …') |
|||
(3 intermediate revisions by 2 users not shown) | |||
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 ]] | ||
+ | * [[Excel spreadsheets read and write]] | ||
+ | * [[Functions To Read Excel Worksheets]] | ||
+ | * [[Functions to Write Data to Excel Worksheets]] | ||
+ | * [[Excel to Analytica Mappings]] | ||
+ | * [[Excel to Analytica Translation]] |
Latest revision as of 16:35, 2 June 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