Noob question about referenced cells and worksheets

[serivas]

Hi there!

I'm making a subroutine that uses a cell reference as an input (the active cell).

My question is: If I pass a range as "ByRef NAME As Variant", does "NAME" have a worksheet "attached" to it, or is it just a location on the active worksheet?

For instance:

Sub Add(ByRef NAME As Variant, j As Integer, k As Integer)

Dim A As Integer

A = NAME.Row + NAME.Column + (NAME's worksheet index/number)
' how would I add NAME's worksheet number?

End Sub

Thanks!

 

[wesborland1234]

I think you want to pass NAME as a Range, not a Variant.

On a Range object you can call the Parent property which has an Index property.

For example:

Private Sub Worksheet_Change(ByVal Target As Range)
 Dim str As String
 str = Target.Parent.Index 'Sets str to index number of worksheet
End Sub