Help with VB code please

[Smudger]

Have tried to use a code posted on this site. I keep getting a " Runtime Error 40036". Code as listed below

Sub CopyThem()
NextRow = Worksheets("Numbers").Range("B65536").End(xlUp).Row + 1
Worksheets("Numbers").Cells(NextRow, 2).Resize(1, 2).Value = Array( _
Worksheets("data").Range("f11").Value, _
Worksheets("data").Range("f12").Value)
End Sub

I am trying to copy data from sheet "Numbers" to sheet "Data"

When I try the code on a blank spread sheet it works fine, but when I try and run it in the existing spreadsheet with existing data I get the error code.

Any Ideas and one ?

 

[shajueasow]

What is the correct name of the other worksheet?
Data or data?

 

[Smudger]

The sheet is called Data.

Is the VB code case sensitive ?

When I debug the error, the line :

NextRow = Worksheets("Numbers").Range("B65536").End(xlUp).Row + 1

is the one that is highlighted.

Don't know if that helps at all.

Do you know what the error "Run-time error 40036 Application-defined or object-defined error" means ?