View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
sedonovan
 
Posts: n/a
Default 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