Run-time error 1004

Certified

Board Regular
Joined
Jan 24, 2012
Messages
189
When I run the following line of code I get the following error
"Run-time '1004': Application-defined or object defined error"

Code:
Range(found2, Cells(Arow, found).End(xlDown)).Offset(1, 0).Select
However, if I run this code without the offset property , I don't get an error.

I am trying to copy all of the data in the selection excluding the first row.

Does any know why I am receiving that error or can suggest an alternative way I write the code to achieve the results I am looking for?

Thanks.
 

Excel Facts

Enter current date or time
Ctrl+: enters current time. Ctrl+; enters current date. Use Ctrl+: Ctrl+; Enter for current date & time.
However, if I run this code without the offset property , I don't get an error.
I often see that when you are in the first/last row/column where the Offset would move you off the sheet.
Try replacing your line of code with this, and let us know what it returns:
Code:
MsgBox Range(found2, Cells(Arow, found).End(xlDown)).Address
 
Upvote 0

Forum statistics

Threads
1,223,911
Messages
6,175,334
Members
452,636
Latest member
laura12345

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top