The VBA script needed should, for the active worksheet, loop through column H from row 2 to the last non-blank cell, replacing the values with the rightmost 8 characters (removing the characters to the left of the 8 on the right).
The VBA script needed should, for the active worksheet, loop through column H from row 2 to the last non-blank cell, replacing the values with the rightmost 8 characters (removing the characters to the left of the 8 on the right).
Try this code:
Please Login or Register to view this content.
Please Login or Register to view this content.
Both work perfectly, thanks!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks