VBA Paste mutliple line text into a single cell

By mark.ivanowski ·
I manually am copying multiple line text from VBE Modules (comments) and paste into a single cell in Excel. See the steps:
In VBE Modules select multiple lines.
In Excel: Select a cell, press {F2} and paste.
How can I write a code to edit Cell {F2} and paste?
I tried the follow and did not work (it pasted to multiple cell instead a single cell)

Sub EditPaste()
'Edit Cell and Paste whatever is in the Clipboard.and UnWrap
Application.SendKeys "{F2}"
Application.Run "PERSONAL.XLSB!UnWrap"
End Sub

This conversation is currently closed to new comments.

0 total posts (Page 1 of 1)  
Thread display: Collapse - | Expand +

All Answers

Share your knowledge
Back to Software Forum
0 total posts (Page 1 of 1)  

Related Discussions

Related Forums