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
[MS.Excel] Determine how many cells contain values Topic is solved
- flyingDman
- Posts: 2817
- Joined: 29 Sep 2013, 19:01
Re: [MS.Excel] Determine how many cells contain values Topic is solved
There are several ways to determine the last row. This is one:
So this will return 5 even though cell 3 is blank:
Code: Select all
xl := ComObjActive("excel.application")
lstrw := xl.Range("A" xl.Rows.Count).End(-4162).Row
msgbox % lstrw
14.3 & 1.3.7
Re: [MS.Excel] Determine how many cells contain values
I try it i got blank MsgBox Should it give me "2" write on (A3) or (A6), Right?
- flyingDman
- Posts: 2817
- Joined: 29 Sep 2013, 19:01
Re: [MS.Excel] Determine how many cells contain values
The message box should show 5 which is the last row.
14.3 & 1.3.7
Re: [MS.Excel] Determine how many cells contain values
I don't know why MsgBox is empty.
i have AHK 1.1.33.10
i have AHK 1.1.33.10
Re: [MS.Excel] Determine how many cells contain values
It was my fault,
It works as expected now, Thank you very much @flyingDman
It works as expected now, Thank you very much @flyingDman