View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
mikeb mikeb is offline
external usenet poster
 
Posts: 36
Default Finding last row in range with blank cells?

perfect, thank you!!!
Mike

"Ron de Bruin" wrote:

Hi Mike

Use a function like i use on this page
http://www.rondebruin.nl/copy1.htm

--
Regards Ron de Bruin
http://www.rondebruin.nl



"mikeb" wrote in message ...
I need to find the last row in a sheet but some columns may have blank cells
in the last row and I don't know which column, how do I work around that?
thanks!