Difference between revisions of "Error Messages/40770"

(Created page with '= 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_row…')
 
 
(One intermediate revision by one other user not shown)
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 columns in the range passed to the function and the length of the index passed as the '''ColIndex''' do not match. The number of columns and the size of the '''ColIndex''' should be equal.
+
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 '''ColIndex''' 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.