Brent

Sub findbottom()
ActiveSheet.Cells(Rows.Count, 2).End(xlUp).Select
End Sub


Gord Dibben Excel MVP

On Fri, 25 Feb 2005 13:39:02 -0800, "Brent E"
wrote:

Good afternoon,

I need to know a VBA command that will look at all cells in Column B until
end of file or EOF. I tried DO UNTIL ... EOF, but didn't seem to work. Is
this valid? Thanks.