Don't confuse EOF -- which refers to the end of a disk file -- with the end of
the data in a worksheet column.

On Fri, 25 Feb 2005 14:13:01 -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. Any
suggestions? Thanks.