Thread: how do I create a macro to auto insert rows?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
aashish
 
Posts: n/a
Default how do I create a macro to auto insert rows?
I have a 1000+ list and i want to enter a blank row after each entry that
does not equal the prior one. The repeated entries are not evenly spaced.
Can a macro look at a value, determine if it's equal to the prior, and if
not, insert a row?

thanks.
Reply With QuoteReply With Quote