data on hidden sheets
 

I have a user form that takes data entered in cells from sheet 1 and deposits
them in cells on sheet 2 and sheet 3 when the add record button is clicked.
If I hide either sheet 2 or 3 I get an error "Select method of worksheet
class failed"

Is there a way to enter data in a hidden sheet?

data on hidden sheets
 

Try withOUT selecting.

Range("a1").Copy Sheets("sheet14").Range("h1")

"Gizmo" wrote in message
...
I have a user form that takes data entered in cells from sheet 1 and
deposits
them in cells on sheet 2 and sheet 3 when the add record button is
clicked.
If I hide either sheet 2 or 3 I get an error "Select method of worksheet
class failed"

Is there a way to enter data in a hidden sheet?