Can't find my Last Row

[jomili]

Okay, I think I'm going crazy: I'm working on a macro, and at the outset I determine my last row, use it, then do an Advanced filter to copy unique values. I then want to refigure my last row to be the bottom of the unique list, but my "Lastrow" code throws up an error, "Method "Range of Object Global" failed". I can't figure out why. Any help would be greatly appreciated.

Please Login or Register  to view this content.

[The_Prist]

LastRow = Range("AH1" & Rows.Count).End(xlUp).Row - wrong. Result - 165536 for 2003 Excel and 11048576

Please Login or Register  to view this content.

[jomili]

Thank you so much. I hate it when I get stuck on something so easy.