MsgBox "The current selection was formatted and copied to the clipboard"Įxpanding on Jeff Atwood's answer, since it would not let me comment there: Output = output line Chr(13) Chr(10) Mid(line, c * cellsize - cellsize 1, cellsize) = Cells(r, c) ' manually add it as the path C:\Windows\System32\FM20.dllĭim selectedrows As Integer, selectedcols As Integer ' add it via Tools / References if it does not appear in the list ' requires a reference to "Windows Forms 2.0 Object Library" To use it, make sure you enable the Developer tab in Excel Options if you are using Excel 2007 or later. This is kind of annoying for "real" plain text output when you have a fixed width font but not necessarily tab delimiter support.Īnyway, I found and modified a small Excel Macro that will copy the currently selected region as a simple fixed-width columns ASCII table - like so: All Excel clipboard output is tab delimited by default. Wow, I was going to ask this question myself but it was already asked.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2022
Categories |