using EOF in VBA

using EOF in VBA

how do i use EOF in VBA instead of using IsEmpty ? (: