Bonjour,
I want to create a button that will copy to windows clipboard the content of the cell left to it.
Example
In cell B1 I have text : "Hello World"
In cell B2 I have a macro button named "Copy"
When I hit the button, the text contained in the left cell is being copied to the clipboard.
Now, I can do that easily with the following code :
What I'd like is somethig relative to where the button is located. If I create the macro button in cell W4, I want the content of the cell W3 sent to the clipboard. I just can't manage to select the right cell along with the SetTect function.![]()
Please Login or Register to view this content.
Thansk for your help.
Regards,
William
Bookmarks