VBA: FIND FIRST ROW
FINDING THE FIRST ROW FOR "KVV"
When I do a filter to the Segment Code for "KVV" , the first row for "KVV" is Row 4.
I have done a Marco to help me find the FIRST ROW of "KVV" but the marco will not go and find the FIRST ROW of "KVV" it will just find the Second Row.
I want the marco help me find the first row of "KVV", that is Row 4.
How am I going to do that??
see attract file to have a clearer view.
column1 = Range("A1").End(xlToRight).Column
Range(Cells(1, 1), Cells(1, column1)).Select
Selection.AutoFilter Field:=5, Criteria1:="KVV"
'it will not offset to the fourth row of "KVV"
'it will select two row, WHY?
Cells(1, 5).Offset(1, 0).Select
firstrow = ActiveCell.Row
firstcolumn = ActiveCell.Column
Video Tutorials / Excel Dashboards Reports