Hello, first post hope you all can help.
I'm trying to write a macro that can merge rows if Column A is blank.
So Test would be row 1 test2 would be row 2. As opposed to test2 being being row 4.
I used JoinRows macro found at mvps.org/dmcritchie/excel/join.htm But am having trouble modify it to see if there are blanks in column A.
Any help or ideas would be greatly appreciated.