Thread: Insert rows
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Lost[_3_] Lost[_3_] is offline
external usenet poster
 
Posts: 2
Default Insert rows

I hope someone can help me with this confusing thing.

I have a large spreadsheet (20,000 rows +) and I have a
date in column R. The sheet has been sorted on column R.

I want the most efficient code I can find to insert two
rows everytime the a different date is found in column R.

Please supply your example code...and thanks millions...