Creating a text file from data - need for the row of data to be variable/selectable

[eq52515]

I can create, copy / paste and save a text file to a specific directory (e.g. All of my data is on the 2nd row...so all of the data will be taken from H2, M2, R2, etc...) How can I make the row that contains my data variable or be able to select a different row of data? It could be one row at a time or if possible, each selected row its own text file. I would be happy to post the code I have if you like.

Any and all help is much appreciated.

TIA

 

[eq52515]

OK, how about this... A msg box asking which row to copy, and then paste that row to a new sheet?