I've been trying to create a macro for a specif need for 3 days, and can't find how...
Hope someone could help me here!
I would like to find and select the row in the column F of Sheet2 (called "Table1" in the macro) that contains the value of the cell F2 of the Sheet1.
Since there's a lot of data in the the column F of Sheet2, I'm using the auto-filter.
Here what I've done:
ActiveSheet.ListObjects("Table1").Range.AutoFilter Field:=5, Criteria1:= _
The macro does find the cell. But it did not select the cell - which is the most important because I need the row number!
Could someone help me on this?
Thanks so much!
Edited by CatherineLavoie, 12 October 2011 - 01:31 PM.