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

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

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

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