how do i find the last cell

S

sedonovan

hi there,

I have a sheet which has a formula in 6 columns and 300 rows. To make my
macro I need to select the last cell which is complete (not necessarily just
has the formula in). As this will vary each time the macro is run, is there a
way of finding this?

Many thanks,
Suzie
 
S

Stefi

Cells.Find(What:="*", _
After:=Range("A1"), _
LookAt:=xlPart, _
LookIn:=xlValues, _
SearchOrder:=xlByRows, _
SearchDirection:=xlPrevious, _
MatchCase:=False).Activate
Regards,
Stefi

„sedonovan†ezt írta:
 
Top