Help with VBA range error

[Chookz]

Hey guys,
I am getting the following error when I run my VBA macro:
Run-time error '1004':
Select method of range class failed.

I am trying to copy data from one workbook to the next empty row in another workbook. This is the part of my code that is returning the error:

emptyrow = Sheets("RawData").Cells(Rows.Count, 1).End(xlUp).Offset(1, 0).Row
Sheets("RawData").Cells(emptyrow, 1).Select
ActiveSheet.Paste


Sheets("RawData").Select
ActiveWorkbook.Save
ActiveWorkbook.Close

The debug error is for this part:
Sheets("RawData").Cells(emptyrow, 1).Select

Any idea what the problem is or how to fix it?
Cheers

 

[VoG]

Maybe

emptyrow = Sheets("RawData").Cells(Rows.Count, 1).End(xlUp).Offset(1, 0).Row
Sheets("RawData").Cells(emptyrow, 1).PasteSpecial Paste:=xlPasteAll


Sheets("RawData").Select
ActiveWorkbook.Save
ActiveWorkbook.Close

 

[Chookz]

Maybe

Thanks mate, works a treat!