_Excel_RangeWrite to unknown range

[Moonscarlet]

Hello,

How can I write to an unknown range in excel?

For example: I am trying to write something to range from cell B2 to B# (# equals to the last row that column A uses since column B is empty).

I've only managed to get the range of the last used cell in column A using :

$LastCell = $oWorkbook.ActiveSheet.Range("A65535").End($xlUp)

then getting the cell next to it in the B column:

$LastinB= $LastCell.Offset(0,1)

Except that nothing happens when I try to write to that range using this:

$Range= "B2:"&$LastinB
_Excel_RangeWrite($oWorkbook,Default,"Test",$Range)

Any help please?

Thanks in advance.

[water]

Did you check the wiki? https://www.autoitscript.com/wiki/Excel_Range#Last_Cell

[Moonscarlet]

15 minutes ago, water said:

Did you check the wiki? https://www.autoitscript.com/wiki/Excel_Range#Last_Cell

Thanks, I guess I just needed to get the row number from the range object by adding ".Row" then add "B" to the string.

$Range= "B2:B"&$LastinB.Row
_Excel_RangeWrite($oWorkbook,Default,"Test",$Range)