That suggests that you do not have a sheet called database. Check the
spelling, and if the sheet has a trailing space.

--
HTH

Bob Phillips

"Anthony" wrote in message
...
I am trying to write some simple code to cope/paste some cells into
another
workbook, here is what I have so far..

Sub copy_new_entry_data()
Application.ScreenUpdating = False
Range("G9:G15").copy
Sheets("database").Select

End Sub

when I try and run this I get an error
"Sunscript out of range"

what does that meen ????

thanks