View Single Post
  #13   Report Post  
Posted to microsoft.public.excel.programming
Jim Cone Jim Cone is offline
external usenet poster
 
Posts: 3,290
Default Transpose data using Vba

RBS,
Thanks for running the numbers. I won't argue. <g

However, I did run a couple of tests of 1000 rows with the data
already filled in the two columns,
MoveEmOver took only about 1/4 second.
But if more was data added the time required increased exponentially.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware


"RB Smissaert"
wrote in message
Did run MoveEmOver on the wrong range and it is in fact 30 secs.
RBS