I want VBA to copy only cells selected in excel to notepad in same format like if there is space between selection then space should appear in notepad & one below the other.
Along with this i want the name "THE END" to appear on the next line of notepad.
Path for notepad should be to save on desktop with file name XXX.txt if any file name with similar name already on desktop then overwrite it.
Output photo is attached.
Thanks for yor time & consideration.
E.g.
A1= Apple
A2=Ball
A4=Cat
then output in notepad should look like
Apple
Ball
Cat
THE END