Difference between revisions of "Error Messages/40770"

 
Line 1: Line 1:
= Error Message Examples =
+
[[Category: Error messages]]
 +
== Error message examples ==
  
  The row index RowIndex passed as a parameter to Function [[Functions_To_Read_Excel_Worksheets#SpreadsheetRange.28workbook.2C_range.2C_colIndex.2C_rowIndex.2C_howToIndex.2C_sheet.29|Spreadsheetrange]]
+
<pre style="background:white; border:white; margin-left: 1em; font-style:italic">
 +
  The row index RowIndex passed as a parameter to Function SpreadsheetRange
 
  does not match the number of rows in the requested region. The index has
 
  does not match the number of rows in the requested region. The index has
 
  13 row(s), while the region has 12 row(s).
 
  13 row(s), while the region has 12 row(s).
 +
</pre>
  
= Cause =
+
== Cause ==
  
The number of rows in the range passed to the function and the length of the index passed as the '''RowIndex''' do not match. The number of rows and the size of the '''RowIndex''' should be the same.
+
The number of rows in the range passed to the function and the length of the index passed as the «RowIndex» do not match. The number of rows and the size of the «RowIndex» should be the same.
  
= Remedies =
+
== Remedies ==
  
Correct either the range in the Excel sheet or the index passed as the '''RowIndex''' so that they are equal.
+
Correct either the range in the Excel sheet or the index passed as the «RowIndex» so that they are equal.
  
<br><comments />
+
==See Also==
 +
* [[Function calls and parameters]]
 +
* [[Functions To Read Excel Worksheets]]
 +
* [[SpreadsheetRange]]
 +
* [[Arrays and Indexes]]

Latest revision as of 20:44, 4 April 2016

Error message examples

 The row index RowIndex passed as a parameter to Function SpreadsheetRange
 does not match the number of rows in the requested region. The index has
 13 row(s), while the region has 12 row(s).

Cause

The number of rows in the range passed to the function and the length of the index passed as the «RowIndex» do not match. The number of rows and the size of the «RowIndex» should be the same.

Remedies

Correct either the range in the Excel sheet or the index passed as the «RowIndex» so that they are equal.

See Also

Comments


You are not allowed to post comments.