Passing a row into a function

[Sandler]

How do I pass a row into a function.

For example if i have a hypothetical function named hypothetical and I am running it on Row 10, I want it to pass row 10 into the function. i.e. =hypothetical(10). If i have the rows filtered and visible are rows 10,15,20.
Then I want to drag down the formula and it grabs the correct row. i.e. =hypothetical(10), =hypothetical(15), =hypothetical(20), respectively.

Thanks.

 

[L. Howard]

An admitted guess...

=hypothetical(Row())

Howard

 

[Sandler]

Thanks, this is what I ended up passing, which worked.

Dim rowNum As Integer

rowNum = row.row

 

[Rick Rothstein]

How do I pass a row into a function.

For example if i have a hypothetical function named hypothetical and I am running it on Row 10, I want it to pass row 10 into the function. i.e. =hypothetical(10). If i have the rows filtered and visible are rows 10,15,20.
Then I want to drag down the formula and it grabs the correct row. i.e. =hypothetical(10), =hypothetical(15), =hypothetical(20), respectively.

The declaration for your function would need to look like this...

Function Hypothetical(Rw As Range)

and you would pass the entire row into the function by calling it like this...

SomeVariable = Hypothetical(Row(10))

Inside the function, the Rw argument would be a range referencing Row 10.

 

[Sandler]

Thank you