Export 2 columns to 2 text files

[bilbo85]

Hello,

I am trying to export some data in column A to one text file and then some data in column B to a separate text file. There could be any number of rows.
Here is what I have so far:

Please Login or Register  to view this content.

This however comes up with a type mismatch error on " Print #1, iRange" and I'm also not sure about how to print column B to a separate text file.

Any help would be greatly appreciated.

Thanks in advance.

[dangelor]

Possibly...

Please Login or Register  to view this content.

[dangelor]

To write out column B, change this

Please Login or Register  to view this content.

to this

Please Login or Register  to view this content.