Create string to copy to clipboard

Hello,
I'm looking for a code to trigger on Worksheet_SelectionChange.

The code will simply copy a string to the clipboard. The string should consist of "http://xyz.com/" and Target.Value.

In the end, the copied text needs to be "http://xyz.com/textfromtargetcell"

Also, this only needs to work for a particular range (ie: F17:F1000)

Any help would be appreciated!

Wow, thank you all for the help. Unfortunately none of them are working!

There must be something else happening.

I do have the Reference library installed. Using YasserKhalil's code above, when I select multiple rows in column F I get a debug error (as I would expect), however, when I click on one it does not copy to the clipboard. None of the code above copied to the clipboard. So strange.

For the record, I'm using Win 10 64 bit, Office 365.

Interesting, when I paste into Notepad, it shows nothing. When I paste here, it shows nothing. When I paste into Word I get two squares with checkmarks in them. (here they are copied from Word ￿￿)

Also, I'm afraid your second bit of code didn't fix that either.. Runtime error 13 Type mismatch

Thank you again for your help with this.

Please Login or Register  to view this content.

pastes to word and notepad

Nigelog, thank you, your code does work in a new blank workbook. Yet, it doesn't work in my current file. I will say that upon opening the file, several queries and pivot tables refresh. The sheet in question does contain a pivot table, and the table from which I'm trying to copy does contain conditional formatting.

I don't see how it's possible, but I suppose one of these could be causing the issue.

maybe upload a sample workbook?

I tried breaking down my file and removing a whole bunch of data, and it started working.
I think the issue boils down to the cell having a formula in it, and not just text. After I deleted all my queries, my formulas became #REF and then VBA started erroring out upon click. Sound possible? When I remove the #REF and change it to a text word it works.

Is there a way to change Target.Value to Target.TextValue or something?

try Target.Value2 and see if that works

try Target.Value2 and see if that works

No such luck I'm afraid

can you try moving the formula to vba? like so:

Please Login or Register  to view this content.

that should put the formula result in what ever range you want.

Originally Posted by dmcgov

can you try moving the formula to vba? like so:

Please Login or Register  to view this content.

that should put the formula result in what ever range you want.

That would be really difficult, maybe impossible. It's part of a table 1000 rows deep.

I've seen this code on a different website? Would somebody be able to help me incorporate it into mine? (the part pertaining to converting the clipboard to text)

Please Login or Register  to view this content.

Originally Posted by nigelog

longshot but worth a try

Please Login or Register  to view this content.

works on formulas here. See table

Your file does the same thing on my end. I click 29 in your table and then paste to a different cell and it puts the two ?? boxes in the cell. This is infuriating! I really do appreciate your help though. Thank you.

Please Login or Register  to view this content.

that appears to just be clearing the clipboard
Think you need to post a workbook