counting the row of certain column in excel Topic is solved

[fossil]

Hello guys, i been trying to get the total number of row in, for example column B in excel, but i am not sure how to allow autohotkey to get the total count in column B, this is my code so far.

Code: Select all

Z::
File = Book1.xlsx
path = %A_WorkingDir%\%File% ; path to workbook 
xl := ComObjGet(path) ; access Workbook object

(Sheet := xl.ActiveSheet).Range("A1:A50")
hello := Sheet.Range("A1", Sheet.Cells(xl.Application.Rows.Count,5).End(-4162)).SpecialCells(12).Count
MsgBox, % hello

[jeeswg]

Try this. Cheers.

Code: Select all

q:: ;excel - get row number for last cell in column
oXl := ComObjCreate("Excel.Application")
oXl.Visible := -1 ;True
oXl.Workbooks.Add
oXl.Range("E10").Value := "x"
xlUp := -4162
vCol := 5
vRow := oXl.Cells(oXl.Rows.Count, vCol).End(xlUp).Row
vAddress := oXl.Cells(oXl.Rows.Count, vCol).End(xlUp).Address(0, 0)
MsgBox, % vRow " " vAddress
oXl := ""
return

[fossil]

Its working now! thanks a lot!!! jeeswg

[mdmc]

Try this. Cheers.

Code: Select all

q:: ;excel - get row number for last cell in column
oXl := ComObjCreate("Excel.Application")
oXl.Visible := -1 ;True
oXl.Workbooks.Add
oXl.Range("E10").Value := "x"
xlUp := -4162
vCol := 5
vRow := oXl.Cells(oXl.Rows.Count, vCol).End(xlUp).Row
vAddress := oXl.Cells(oXl.Rows.Count, vCol).End(xlUp).Address(0, 0)
MsgBox, % vRow " " vAddress
oXl := ""
return

Hello,
I'm just starting to grow up on this program, but I want to know. we solve a similar problem.
But I couldn't fully understand the code it was writing. Can you help me?