Help with _Excel_RangeDelete

[linbin]

#include <Array.au3>
#include <Excel.au3>
#include <MsgBoxConstants.au3>

Local $aiResult = 2
Local $sRange1 = '"' & $aiResult & ':' & $aiResult+1 & '"'
Local $oAppl = _Excel_Open()
Local $oWorkbook = _Excel_BookOpen($oAppl, @ScriptDir & "\1.xls")

;_Excel_RangeDelete($oWorkbook.ActiveSheet, "2:3")
_Excel_RangeDelete($oWorkbook.ActiveSheet, $sRange1)
If @error Then Exit MsgBox($MB_SYSTEMMODAL, "Excel UDF: _Excel_RangeDelete Example 1", "Error deleting cells." & @CRLF & "@error = " & @error & ", @extended = " & @extended)

Error Msg:

@error=2,@extended = -2147352567

_Excel_RangeDelete($oWorkbook.ActiveSheet, "2:3") work, _Excel_RangeDelete($oWorkbook.ActiveSheet, $sRange1) don't.

How to modify it?

[water]

How about:

Local $sRange1 = $aiResult & ':' & $aiResult+1

[Jos]

@linbin,

Why did you create a new member account in stead of sticking to bin123485?

Jos

[bin123485]

@linbin,

Why did you create a new member account in stead of sticking to bin123485?

Jos

 

Too many numbers. so stupid id.