I did a lot of research but haven't found exactly what I need. I
believe syntax is all correct below; so here is what I have so far:

Copying info in a cell:
------------------------
Sub Copy_to_Clipboard_CELL()
'
ActiveSheet.Range("A2").Select
Selection.Copy
End Sub


Copying a range:
---------------
Sub Copy_to_Clipboard_RANGE()
Range("A1:AI35").Select
Selection.Copy
End Sub


But what would be ideal is to just "send" some text to the clipboard,
specifically, the syntax for the hyperlink function. I have a sheet
which is all about tracking URLs and it would be really handy to just
click a button and have that go to the clipboard so it's available for
pasting ('course, a userform where I enter both sides of the info
needed [URL+NAME] for a hyperlink would be better, but I looked at
that earlier today and it's too advanced for me right now <g). So
copying the syntax to clipboard really great alternative.

The syntax I'd like to send is this, pretty standard stuff:

=HYPERLINK(" URL ", " name ")

Thanks! :oD