Create Right Click Option to Copy Cell Address
I want to create a right click option in Excel that I can use in every
spreadsheet, that allows me to copy and past the active range of a
spreadsheet. So when I highlight a range, I want code that extracts
Sheet1!A1:A46, copies it to the clipboard. Assuming the code looks like this
for the string.
ActiveRange.Parent.Name & "!" & ActiveRange.Address
How do I create the right click option AND where do I put the code (personal
workbook!).
Thanks
EM
|