VBA gurus,
I am in need of some help with a macro. I am trying to find some code for a macro that inserts a line above and below a set of values each time the value changes. For example, in the data set below, I need to insert a line before the UDWQ3 code string and after. Then i need it to move on to the next data set in the column (UUMC13) and do it again. Suggestions??
UDWQ3
UDWQ3
UDWQ3
UDWQ3
UDWQ3
UDWQ3
UDWQ3
UDWQ3
UDWQ3
UDWQ3
UDWQ3
UDWQ3
UDWQ3
UDWQ3
UDWQ3
UDWQ3
UDWQ3
UDWQ3
UDWQ3
UDWQ3
UDWQ3
UDWQ3
UDWQ3
UDWQ3
UDWQ3
UDWQ3
UDWQ3
UDWQ3
UDWQ3
UDWQ3
UDWQ3
UDWQ3
UUMC13
UUMC13
UUMC13
UUMC13
UUMC13
UUMC13
UUMC13
UUMC13
UVWTP
UVWTP
UVWTP
UVWTP
W00173
W00177
W00177
W00177
W06015
W06015
W06015
W06015
W06015
W06015
W06015
W06015
W06018
W06018
W06018
W06023
W06024
W06024
W06024
W06024
W06024
W06024
W06024
W06024
W06024
W06024
W06024
W06024
W06024
W06024
W06024
W06024
W06024
W06024
W06024
W06024
W06024
W06024
W06024
W06024
W06024
W06024
W06024
W06024
W06024
W06024
W06024
W06024
W06024
W06024
W06024
W06024
W06024
W06024
W06024
W06024
W06044
W06044
W07001
W07001
W07001
W08005
W08005
Bookmarks