Ok...so specify the from where and the to where.

There is no recordset involved here. It is simply copying a number from one place to another.

If you want to "move" it, then after the copy, delete it from sheet1