Getting the current row number in Excel

[strangeBrew12]

I know this is simple, but I am drawing a blank this morning. What is the syntax to get the current row. I want to put this value into a variable as I am doing quite a bit of data parsing.

intRow = ????

Thanks

JJ

 

[AnotherHiggins]

in Excel itself,

=row()

If you are in VBA,

intRow = ActiveCell.Row


[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ181-2886 before posting.