Named data into macro
On Thu, 20 Mar 2008 14:16:00 -0700 (PDT), Buzz
wrote:
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
Try this procedu
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
|