Hi Glen;

Try this

Sub try()
Cells.Copy
Workbooks.Add
ActiveSheet.Paste
Application.CutCopyMode = False
Application.DisplayAlerts = False

ActiveWorkbook.SaveAs Filename:= _
"C:\Documents and Settings\Administrator\My
Documents\MyTextFile.csv", _
FileFormat:=xlCSV, CreateBackup:=False
Range("A1").Select
End Sub


-----Original Message-----
Apologies in advance for this stupid question. I am
attempting to write a
short macro for a co-worker that allows a user to select
a range of
spreadsheet data then save the selected data to a text
file. How do you
select the data then start the macro and reference the
selected data within
the macro? Everything I've tried chokes during debug.
The operation seems
trivial but apparently to this old boy , isn't.
.