Easy Q: Visual Basic and Excel

  • Thread starter Thread starter Icemak
  • Start date Start date
I

Icemak

Hello.

I have a hopefully simple problem that I hope someone here can answer
for me or lead me in the right direction.

I have a very simple data.xls file that just has 1 sheet with two
columns that contain text. (like a lookup translation table).

Whats the easiest way to query this file looking for "Blah" in ColA and
get the "Foo" from ColB (Using Visual Basic)?

I understand the basics on how top open a file and loop through cells,
but there must be an easier way to quickly query the columns?

Any help is greatly appreciated.

Thanks.
 
Thanks for the start... just cant figure out the named range things..
just wish I could access the whole column.
 
Back
Top