When I run the following line of code I get the following error
"Run-time '1004': Application-defined or object defined error"
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.
"Run-time '1004': Application-defined or object defined error"
Code:
Range(found2, Cells(Arow, found).End(xlDown)).Offset(1, 0).Select
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.