Chookz
Board Regular
- Joined
- May 9, 2011
- Messages
- 95
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:
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
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:
Code:
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