I wish to copy the reference to a Range in Excel as a String as efficiently as possible. I wish primarily to minimise keystrokes and conditionally not use custom VBA or the mouse.
At the minute, I use the following keystroke sequence to achieve my goal:
Selection of range then
Ctrl+c. This opens up the
Define Name dialog and copies the desired string from the
Refers To box.
However, this feels remarkably awkward and I suspect that there may be a better way to achieve this operation.
After selecting the range, place
=Sheet1!$C$3:$G$11 as a string in the clipboard
I am manually testing software that logs to Excel. I must reference Ranges from the log in a separate worksheet to evidence the outcome of testing as part of logging if the test has passed or failed. Generally I am pasting the string from the clipboard into an Excel cell, which usually involves pressing
f2 to edit a cell contents, navigating the cursor to the appropriate position within a pre-existing string and pasting the string from the clipboard.