Hi, I'm new to the forum and not an advanced excel user.
I'm trying to use SendKeys to select all the contents of the active cell copy and paste to Notepad. The reason I want to use SendKeys is so that the cell is in edit mode to keep the formatting I've entered after pasting into Notepad or Word.
Here's what I'm trying but I'm missing the select all & copy step:
Range("A1").Value = ActiveCell.Value
Range("A1").Select
SendKeys "F2"
<<Select ALL & COPY>>
Shell "notepad.exe", vbNormalFocus
SendKeys "^V"
I have basic-midlevel knowledge of programming so I can cut and paste things together in VB, but a little help would be appreciated!
Bookmarks