Tony
One way is to name the range of all the data entry cells (the cells you
want cleared), say, "DataEntryCells". The code to clear these cells is
then:
Range("DataEntryCells").ClearContents
HTH Otto
"Tony" wrote in message
...
I have a worksheet that I have created a data entry form. When I copy the
data to the worksheet, I want to clear the data entry fields.

The first field is called: RecordNo

What code can I use for this?