Getting current row number in VBA

[beakerboy]

I'd like to be able to determine the row number of the cell currently calling a specific funcion. Currently I call a public function as

=Find_Last_Entry(Glucose_Consumed,ROW())


I'm hoping there's a way for the VB to determine the row on it's own. I can't use Activecell.Row because the cell with this formula isn't always active.

Any Ideas?

Thanks
Kevin Nowaczyk

 

[cheerio]

The only way is to provide the function with the row number using the ROW() function.

A function can be called from another function or macro so you cannot assume it will be called from a cell.

VBA questions are better posed in the VBA forum.

 

[combo]

Since excel XP it is possible to use ThisCell property of Application object, returning the cell using UDF (as range object, Application.ThisCell.Row will return row number).

combo

 

[SkipVought]

Hi,

If you have data in every cell in the subject column, then the last row can be obtained using the COUNTA function.

For instance in column A...
[tt]
=COUNTA(A:A)
[/tt]
if you have empty rows above, subtract the number of empty rows.

Skip,

_{[red]Be advised:[/red] Researchers have found another Descartes trueism, "Cogito ergo spud."
"I think; therefore, I YAM!}