View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Finding first Null value in range?

LastRow = Cells(rows.count,5).End(xlup).Row
might work

or
LastRow = Range("E241").End(xlup).Row

Regards,
Tom Ogilvy

"Karl Thompson" wrote in message
...
This always return an error:

LastRow = Application.Match("", Range("E1:E240"), 0)

though E90 is blank.

What gives?