[MS.Excel] Determine how many cells contain values Topic is solved

[HiSoKa]

Hello, I have a large number of CELL contain values in the column.
I want to put the number of these fields in the clipboard so that I can deal with this number later,
Such as writing something on the first CELL after this number ... and so on.

For example,
I have column A and all the cells Between 1 and 150 contain something (Number or text).
I want to put the number 150 in the clipboard so that I can write asomething later on the field 150 + 1..

I Hope my question is clear, thank you

[flyingDman]

There are several ways to determine the last row. This is one:

Code: Select all

xl := ComObjActive("excel.application")
lstrw := xl.Range("A" xl.Rows.Count).End(-4162).Row
msgbox % lstrw

So this will return 5 even though cell 3 is blank:

20220627_072841.jpg (2.48 KiB) Viewed 488 times

[HiSoKa]

I try it i got blank MsgBox Should it give me "2" write on (A3) or (A6), Right?

Untitleds.png (134.8 KiB) Viewed 476 times

[flyingDman]

The message box should show 5 which is the last row.

[HiSoKa]

I don't know why MsgBox is empty.
i have AHK 1.1.33.10

[HiSoKa]

It was my fault,
It works as expected now, Thank you very much @flyingDman