Thread: Modify macro code to export multiple cell contents to multiple Text Files
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Stopher Stopher is offline
external usenet poster
  
Posts: 67
Default Modify macro code to export multiple cell contents to multiple Text Files
Your macro relies on you selecting a range, so if you click on the top
cell in column D you want to convert to a txt file and CRT-SHF- Down
Arrow and then run the macro it should work. To incorperate this into
the macro you need something like

Range("D1").Select
Range(Selection, Selection.End(xlDown)).Select

Regards

Stopher

Reply With QuoteReply With Quote