Couple questions:

- Does the .txt file already exist, or are you wanting to create a new .txt
file with just the table in it?

- Do you want two 1x100 tables or one 2x100 table?

--
Frank

"Do or do not; There is no try"
-Yoda


"gedinfo" wrote:

I would like to be able to copy two columns from a .xls file, columns 2
(B) and 9(I) into a .txt file for approximately 100 rows, using VBA.
What is the best way to do this?

Thank you
.