Difference between revisions of "Error Messages/41146"

(Cause)
 
Line 1: Line 1:
= Error Message Examples =
+
[[Category: Error messages]]
  
In the call to Function [[Spreadsheetrange#SpreadsheetRange.28workbook.2C_range.2C_colIndex.2C_rowIndex.2C_howToIndex.2C_sheet.29|Spreadsheetrange]], you have specified the worksheet twice,
+
== Error message examples ==
in the parameter <<range>>='Sheet1!A1:B5' and in the parameter <<sheet>>="Sheet1".
+
  
= Cause =
+
<pre style="background:white; border:white; margin-left: 1em; font-style:italic">
 +
In the call to Function SpreadsheetRange, you have specified the worksheet twice,
 +
in the parameter «range» = 'Sheet1!A1:B5' and in the parameter «sheet» = "Sheet1".
 +
</pre>
  
You have specified the sheet in both the <<sheet>> parameter and <<range>> parameter. To prevent ambiguity/confusion, you are allowed to specify the sheet only once.
+
== Cause ==
  
= Remedies =
+
You have specified the sheet in both the «sheet» parameter and «range» parameter. To prevent ambiguity/confusion, you are allowed to specify the sheet only once.
 +
 
 +
== Remedies ==
  
 
Pass in the sheet to only one of the parameters instead of passing it to both the parameters.
 
Pass in the sheet to only one of the parameters instead of passing it to both the parameters.
  
<br><comments />
+
==See Also==
 +
* [[Function calls and parameters]]
 +
* [[Functions To Read Excel Worksheets]]

Latest revision as of 20:13, 11 April 2016


Error message examples

 In the call to Function SpreadsheetRange, you have specified the worksheet twice,
 in the parameter «range» = 'Sheet1!A1:B5' and in the parameter «sheet» = "Sheet1".

Cause

You have specified the sheet in both the «sheet» parameter and «range» parameter. To prevent ambiguity/confusion, you are allowed to specify the sheet only once.

Remedies

Pass in the sheet to only one of the parameters instead of passing it to both the parameters.

See Also

Comments


You are not allowed to post comments.