Thread: insert a row when theres change in a row.
View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
  
Posts: 35,218
Default insert a row when theres change in a row.
It takes a long time!

Try turning calculation to manual (tools|Option|calculation tab) to see if that
helps.



elaine wrote:

It works perfectly if I only have a few rows of data, but it seems to
take a long time/crashing when I use this code on a 30,000 rows
data.... How long does it take the code to work for 30k rows???

--

Dave Peterson
Reply With QuoteReply With Quote