Finding first Null value in range?

[Karl Thompson]

This always return an error:

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

though E90 is blank.

What gives?

 

[Tom Ogilvy]

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

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

Regards,
Tom Ogilvy