What would be code to get columns A and B to look like in columns G and H. So at the beginning of every chain to add BEG, and at the end END.
What would be code to get columns A and B to look like in columns G and H. So at the beginning of every chain to add BEG, and at the end END.
Hello salso69,
Welcome to the Forum!
The macro below will sort the chains as you requested. A button has been added to the worksheet to run the macro.
Please Login or Register to view this content.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Star below the post.3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Thank you so much it works!!!
Can this line be changed to work with any sheet name
Set Wks = Worksheets("Sheet1")
Hello salaso69,
To make the macro with any worksheet, change the assignment statement to this...
Please Login or Register to view this content.
What to say, THANK YOU!!!
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks