AHK: Excel_Autofilter

[inseption86]

Hi guys, help me please, how to get value from the second line after the filter

Code: Select all

xl.Worksheets(1).Range("A1:AF1").AutoFilter(7, "eng")
Lang := xl.Worksheets(1).AutoFilter.Range.Columns("E").SpecialCells(12).row + 1.value ???????

[Datapoint]

Code: Select all

Lang := xl.Worksheets(1).AutoFilter.Range.Columns("E").SpecialCells(12).row + 1.value ???????

SpecialCells returns a Range object, so you should be able to use Range.Offset like this:

Code: Select all

Lang := xl.Worksheets(1).AutoFilter.Range.Columns("E").SpecialCells(12).Offset(1, 0).Value

[AlphaBravo]

I think you have to loop through visible cells

Code: Select all

for c in xl.Worksheets(1).AutoFilter.Range.Columns("E").SpecialCells(12)
{
	if A_Index = 2 				; second row after title
	{
		MsgBox % c.address " = " c.value
		break
	}
}

[inseption86]

Code: Select all

Lang := xl.Worksheets(1).AutoFilter.Range.Columns("E").SpecialCells(12).row + 1.value ???????

SpecialCells returns a Range object, so you should be able to use Range.Offset like this:

Code: Select all

Lang := xl.Worksheets(1).AutoFilter.Range.Columns("E").SpecialCells(12).Offset(1, 0).Value

Thank you

Code: Select all

MsgBox % xl.Worksheets(1).AutoFilter.Range.Offset(1, 0).Columns("E").SpecialCells(12).value)

But, if i have two and three row, this is

Code: Select all

MsgBox % xl.Worksheets(1).AutoFilter.Range.Offset(2, 0).Columns("E").SpecialCells(12).row

not working