View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
jeffbert jeffbert is offline
external usenet poster
 
Posts: 50
Default 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