type mismatch
thanks dave
"Dave Peterson" wrote:
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
|