Here is what i have so far, After the message box but before it runs the shell command is when I want it to be copied. Your response is a little unclear, as I am not as Advanced at this as I like to act like I am. Could you dumb it down for me? Thanks for the quick response as well!
Sub...
I am having trouble programming a macro to copy the text from the formula to the clipboard so I can use it in another program. Selection.Copy doesn't work when pasting, just copies a blank line. Here is an example of what I want to do:
Run Macro
Copy data from formula bar, (ie. JohnSmith)...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.