Insert rows in depending on criteria in variable columns
I would like to thank everyone in advance for looking into this for me.
I currently have a macro that inserts a blank row after every cell in column
A that changes. See below:
Tom
Tom
Tom
Dick
Dick
Harry
Harry
Harry
The macro would insert a row after the 3rd Tom, the 2nd Dick, and the third
Harry. I have come across the need to be able to pick which column I want the
macro to examine. Sometimes column A, sometimes AB, etc. Any suggestions?
Thanks again
Jeff
|