named range in macro call
Two options:
Private Sub CommandButton1_Click()
Call macro1(Range("NamedRange1"))
End Sub
or
Private Sub CommandButton2_Click()
Dim myRng As Range
Set myRng = Range("NamedRange2")
Call macro1(myRng)
End Sub
Regards,
Per
On 1 Apr., 21:46, hjc wrote:
I have written a macro that I would like to have operate the same way on
different data ranges. *I tried creating a generic macro that accepted a
range of data as an input parameter, then I created several buttons that each
called the same macro, but with a different argument, as follows:
Private Sub CommandButton1_Click()
* * Call Macro1( "NamedRange1" )
End Sub
Private Sub CommandButton2_Click()
* * Call Macro1( "NamedRange2" )
End Sub
and so on. *However, I can't seem to find the right syntax for specifying a
range name in the call to the macro (if there is one). *Even if I have to use
cell references instead of a named range, I could live with that. *Does
anybody know if there is a way to do this?
Thanks!
|