Insert rows in depending on criteria in variable columns
hi,
first think to come to mind....
you can use inputbox to prompt for parameters.
in this case it might be column letter.
but since you didn't post any code, i have no idea where
to put it or how to use it.
-----Original Message-----
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
.
|