how do i find the last cell
 

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

how do i find the last cell
 

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

€žsedonovan€� ezt Ã*rta:

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