View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
No Name
 
Posts: n/a
Default 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







.