Jay Baker
New Member
- Joined
- Dec 9, 2003
- Messages
- 15
I'm trying to select the first empty cell in a column (say column A) so I can paste some data.....the funny thing is, in my long subroutine the following code works, at times
But at other places, I keep getting Run-time error 1004 Application defined or Object defined error.
code:
Worksheets("INPUT").Select
Range("A2").Select
Selection.Copy
Worksheets("SALES").Select
Range("A1").End(xlDown).Offset(1, 0).Select
ActiveSheet.Paste
Thanks,
Frustrated,
Jay
But at other places, I keep getting Run-time error 1004 Application defined or Object defined error.
code:
Worksheets("INPUT").Select
Range("A2").Select
Selection.Copy
Worksheets("SALES").Select
Range("A1").End(xlDown).Offset(1, 0).Select
ActiveSheet.Paste
Thanks,
Frustrated,
Jay