I've got a question on EOF command in VBA

[Guest]

Good afternoon,

I am using an Access module to control Excel and I need to know a VBA
command that will increment thru and look at all cells in Column B on an
Excel worksheet until
end of file or EOF. I tried DO UNTIL ... EOF, but didn't seem to work. Any
suggestions? Thanks.

 

[Ken Snell [MVP]]

see reply in other newsgroup where you posted this same question.