Hi all,
Using VBA, I am trying to get 5 values each at 50 characters out of a single character string. (Max String char capped at 250.)
Any help would be appreciated!
Regards,
Nironto
HTML Code:
Hi all,
Using VBA, I am trying to get 5 values each at 50 characters out of a single character string. (Max String char capped at 250.)
Any help would be appreciated!
Regards,
Nironto
HTML Code:
Maybe this
Please Login or Register to view this content.
Thanks,
Mike
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved.
Thanks Mike!
Your answer was close to what I want and gave me the clue. I modified it to below and it works.
Thanks for your help!
Regards,
Nironto
HTML Code:
In a loop.
Please Login or Register to view this content.
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
Thanks Bakerman2! Simplify the code further!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks