Go to named range nominated by user
 

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

Go to named range nominated by user
 

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

Go to named range nominated by user
 

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

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