Hello,
could someone please help me out with a code that copies everything from one worksheet, creates a new notepad / text file, pastes everything into the notepad file, activates the worksheet and sets the format for all cells to text, opens the notepad file again and copies everything from there back to the worksheet?
After that the Notepad file can be closed without saving / deleting.
Many thanks,
Dennis
could someone please help me out with a code that copies everything from one worksheet, creates a new notepad / text file, pastes everything into the notepad file, activates the worksheet and sets the format for all cells to text, opens the notepad file again and copies everything from there back to the worksheet?
After that the Notepad file can be closed without saving / deleting.
Many thanks,
Dennis