Hi all,
I have the following loop that goes through Column T and separates a cells contents in to new rows based on the presence of a line break Char(10). The function works providing that every cell in column T has something in it.
How could I change this code so that it will work past cells that dont contain anything and still perform the intended function with those cells that do?
Please Login or Register to view this content.
Example data attached
Like this.
Please Login or Register to view this content.
Last edited by bakerman2; 09-24-2016 at 07:35 PM.
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.
Thank you very much. Had me stumped!
You're welcome and thanks for adding rep points.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks