Using current region

Hello. If I use

Please Login or Register  to view this content.

does it change anything if A2:A3 are selected in the workbook?

Range("A1").CurrentRegion is the same as select A1 and press Ctr+A
and it does not depend on the current selection

I wonder why I'm getting an error then. Could you take a look?

maybe so

Please Login or Register  to view this content.

Oops. I forgot to delete out some stuff. Try it out now. It errors on the part with your code.

Also, no need to recode other parts of the code. They work just fine. The only piece that doesn't work is the code that you gave me previously.

I don't get it. I changed my code to this and it worked perfectly. But that was copying and pasting yours. When I try to just retype the changes in my original code it doesn't work. My original code is the second below.

Please Login or Register  to view this content.

Below is the same exact code (I think) but it's throwing back errors. It says "excel cannot complete this task with available resources. Choose less data or close other applications." Then it calculates and says "application defined or object defined error" on the offset part of the code.

Please Login or Register  to view this content.

Figured it out. Forgot the .Rows and .Columns. Me so stupid.