View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ivan Raiminius Ivan Raiminius is offline
external usenet poster
 
Posts: 258
Default End(xldown) not always going to last cell?

Hi Duncan,

you can use:

range("F" & application.rows.count).end(xlup).offset(1,0).sele ct

If I understood your question correctly.

Regards,
Ivan