I have been using the following to return the name of the selected range
which did work once, but has suddenly stopped working.
Not sure why but if anyine has a solution?
Code:
strRange = Target.Name.Name
Not sure why but if anyine has a solution?