ulfal028
07-20-2006, 02:29 AM
Hi,
I'm using a single userform (showmodal = false) on various sheets. What I'm looking for is to specify the active sheet as a parameter and then refer to this parameter for certain tasks.
Sort of:
Dim X As Long
X = ThisWorkbook.ActiveSheet
Sheets("Test").Range("AB22").Copy _
Destination:=Sheets(X).Range("F2")
I'd also like to specify an active cell this way, appreciate some help.
I'm using a single userform (showmodal = false) on various sheets. What I'm looking for is to specify the active sheet as a parameter and then refer to this parameter for certain tasks.
Sort of:
Dim X As Long
X = ThisWorkbook.ActiveSheet
Sheets("Test").Range("AB22").Copy _
Destination:=Sheets(X).Range("F2")
I'd also like to specify an active cell this way, appreciate some help.