Hello to all,
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>
I’ll be the first to admit, I consider myself an average user and know nothing about VBA.
I’m hoping one of you experts can help me with copying a range of cells into notepad and saving it as a .txt file onto a user’s desktop. The filename of the text is one listed in one of the cell’s.
Example:
Range of cells to copy to notepad: A1:A20
Cell to name filename of text file: A24
Thank you
Rob
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>
I’ll be the first to admit, I consider myself an average user and know nothing about VBA.
I’m hoping one of you experts can help me with copying a range of cells into notepad and saving it as a .txt file onto a user’s desktop. The filename of the text is one listed in one of the cell’s.
Example:
Range of cells to copy to notepad: A1:A20
Cell to name filename of text file: A24
Thank you
Rob