G
Guest
Guest
I Have a sheet with a range of cells that i want to search so that i can find the last cell in the range that contains any data.
ActiveCell.Offset(1, -13) = CODE
Cells.Find(What:="*", After:=[A1], _
SearchDirection:=xlPrevious, LookIn:=xlValues).Select
I am using the above code but this is searching the whole sheet and not just the range of cells that i want to look at within the sheet. These are (c2:t200). Does anyone know the best way to resolve this problem...
Thx
Roy
ActiveCell.Offset(1, -13) = CODE
Cells.Find(What:="*", After:=[A1], _
SearchDirection:=xlPrevious, LookIn:=xlValues).Select
I am using the above code but this is searching the whole sheet and not just the range of cells that i want to look at within the sheet. These are (c2:t200). Does anyone know the best way to resolve this problem...
Thx
Roy