Hi guys,
The BlanksToSkip() code I use all the time and want to modify it, so it can work within the sub Sample().
I have highlighted where it trips up. In the past I have had to use "Active.worksheet" before calling BlanksToSkip(). I would prefer to have a way for BlanksToSkip to work regardless, or maybe another parameter as the worksheet? whatever is best.
Thanks!
Jimmy
Please Login or Register to view this content.
Please Login or Register to view this content.
It seems to work when I comment out the 'X2.Select. I think. thanks AlphaFrog. I still need to check something else though.
Like there is another problem that's linked to this, but I am going to continue it on the related thread:
https://www.excelforum.com/excel-pro...ml#post4807023
...
I just tired this again, and I had to UNCOMMENT out the 'X2.Select to get it to work..
So I problem is a bit of a weird one.
Bookmarks