Anthony's VBA Forum

[Africankid]

Hi There!

This is a real amateur question but here goes!!

Basically I need to get data from a spreadsheet and write that data to an external file (eg a txt file on note pad).

For example if the Column A contains: 1,2,3,4,5
I can select individual cells and print them to a txt file using x= Range("A5").Value and then printing x.

But how do I select the entire column and then print each value independly? In other words can i set up a loop that changes the Range value that I need automatically- and whilst still in that loop print the current value?

Any ideas/help would be great- thanks for all your time!!

[Guest]

You can use the for...next loop or the for...each loop.