Forum Discussion
Returning a Text string from =CONCAT, only show value?
In my org, I we needed to generate HTML code for email buttons. So that people wouldn't need to code, and so that I wouldn't need to keep writing new code for them, I created a simple HTML generator ...
CKurtz You could use a simple macro like this one:
Sub copytext()
Dim dataObj As DataObject
Set dataObj = New DataObject
With dataObj
.SetText Range("A20").Text
.PutInClipboard
End With
End Sub
It requires a reference to the MSForms 2.0 library, which can easily be added by inserting a userform in your VBA project (and removing it again)
- Interesting!
Admittedly, I have never used macros. I guess now is as good a time as any to learn!
