It depends on how you want your data in the text file formatted.
A simple way is

Open "H:\Test.txt" For Output As #1
Print #1, Range("A1").Value, Range("A1").Address
Close #1


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"riggi" wrote in message
oups.com...
Hello
I was wondering is it possible to save a cell value in a txt
file and
plus specify which row and column you want to put that value in
that
text file??


PS: I know how to save the worksheet as a text file.


Thanks