OK, excel is excel and text is text. Do you know how to start a blank ext file in VBA? Copy the range, copy it to a variable, open a blank text file and paste it, save it. Let us know where you get stuck at. We are not going to author you a turn key solution, but we will help if you get stuck. Let us know where you get stuck!