is it possible to get the last row of a range, where the range spans several columns of data?
L larry Jun 10, 2004 #1 is it possible to get the last row of a range, where the range spans several columns of data?
D Don Guillett Jun 10, 2004 #2 try lastrow = Sheets("Sheet12").Cells.Find("*", searchdirection:=xlPrevious).Row MsgBox lastrow
