Go to named range nominated by user
You are welcome. Thanks for the feedback.
--
Jacob
"BeSmart" wrote:
That worked brilliantly - Thanks heaps.
--
BeSmart
"Jacob Skaria" wrote:
Try the below macro which works on the active sheet. Edit the destination
cell to suit your requirement
Sub Macro()
Dim strNamedRange As String
strNamedRange = InputBox("Enter the named range")
If strNamedRange < "" Then
Range(strNamedRange).Copy Range("G1")
End If
End Sub
--
Jacob
"BeSmart" wrote:
Hi
I'm a novice macro user - I apologise in advance.
In Office 2007 excel I want to create a macro that:-
1. Creates a msg book and asks the user to enter a named range e.g. "Nov_09"
2. Go to that named range on the current worksheet
3. Copy and paste values within that named range
End.
I searched past threads but I couldn't find anything that deals with a user
nominating the named range.
--
Thank for your help
BeSmart
|