Named data into macro

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Buzz - 20 Mar 2008 22:16 GMT

Hello,

I have a named range on one sheet that I want copied to another sheet
when it is Activated

How do I get the macro to enter the data from a Named range?

Buzz

Reply to this Message

Lars-Åke Aspelin - 20 Mar 2008 22:56 GMT

>Hello,
>
[quoted text clipped - 4 lines]
>
>Buzz

Try this procedure:

Sub copy_range_of_data(fromRange As Range, toRange As Range)
fromRange.Copy
ActiveSheet.Paste Destination:=toRange
Application.CutCopyMode = False
End Sub

Hope this helps / Lars-Åke

Reply to this Message

Per Jessen - 20 Mar 2008 23:13 GMT

Hi
Put this code in the codesheet for the worksheet you want to copy to and
edit references to suit your needs.

Private Sub Worksheet_Activate()
Sheets("Sheet1").Range("NamedRange").Copy
ActiveSheet.Paste Destination:=Range("A1")
End Sub

Regards,

Per

> Hello,
>
[quoted text clipped - 4 lines]
>
> Buzz

Reply to this Message