I am very new to this whole VBA thing so I need elementary explanation on how to copy a range of cells from a worksheet A1:G50 and paste them into a .txt file using a macro. Im sure it can be done but all my efforts have been in vain. If possible Id like the macro to create the .txt file,then paste the range into it as well as name the file Port Log 1. Any help would be tremendously appreciated as im usually able to figure these problems out on my own. But this one is way above my skill level.