Hi,
I know how to find the last row in a column:
[vba]
MyLoc = ActiveCell.AddressLocal(RowAbsolute:=False, ColumnAbsolute:=False)
MyLoc = Left(MyLoc, Len(MyLoc) - 2)
Range(MyLoc & Rows.Count).End(xlUp).Select
[/vba]
Now I just need to know how to find the last column in a row where there are blank cells in the row preventing me from doing:
[vba]
Selection.end(xltoRight).select
[/vba]
Please help!!!! :-)