I bet you want the row number:

rw2 = Sheets("NI").Range("A9").End(xlDown).row + 1

If you leave off .row, then excel assumes you want the .value (and who knows
what that might be).



John wrote:

i get a type mismatch error in the following line; rw2 =
Sheets("NI").Range("A9").End(xlDown) + 1

any ideas?

--

Dave Peterson