Well. no it isn't an integer when the row number exceeds 32 thousand
something---I think it is about 32760 or so.
Set it to single if you exceed the 32k limit

Dave

"John Gittins" wrote in message
...
Just a point but the return from "ActiveCell.Row" is an Integer

"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