I have tried searching for a solution to this issue before I posted but I couldn't get around the issue.
Here's part of the code
Please Login or Register to view this content.
My problem is here (right before the text-to-columns bit):
I get the error mentioned in the title.Please Login or Register to view this content.
I've also tried:
But I get the "Select method of Range class failed" error.Please Login or Register to view this content.
I know that ".Select" is not efficient but I'm trying to run the text-to-columns on P2 until the bottom of that column.
I also know, from searching, that this is a fairly common issue, so I'd also like to know: what is the cause of this problem?
Bookmarks