Also works if you set the variable up as a Integer, which you can use to do
counts and such with.
"Ed" wrote in message
...
Paul:
I have "Dim rngR As String" and use "rngR = ActiveCell.Row" to collect the
row number and use it later ("Range("AB" & rngR).Select").
HTH
Ed
"paul" wrote in message
...
Embarassingly, I don't know how the get the current row
number in VB :-(
Paul