Difference between revisions of "Error Messages/41142"

Line 1: Line 1:
= Error Message Examples =
+
[[Category: Error messages]]
  
When calling function [[Functions_To_Read_Excel_Worksheets#SpreadsheetRange.28workbook.2C_range.2C_colIndex.2C_rowIndex.2C_howToIndex.2C_sheet.29|Spreadsheetrange]], the indicated named cell range, 'Losses', was not found.
+
== Error message examples ==
  
= Cause =
+
:<code>''When calling function SpreadsheetRange, the indicated named cell range, 'Losses', was not found.''</code>
  
You have passed a range-name that does not exist in the passed worksheet.
+
== 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.
  
<br><comments />
+
==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


You are not allowed to post comments.