LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 396
Default Insert calculation with VBA is slow

Hi all, i have a spread sheet that i have to insert two calculations in,
in columns "I" & "J" and i am doing it by looping down the sheet as the
length is variable, sometimes 100 rows and sometimes 10,000 rows !! My
question is, is there a quicker way to do this, as when you get to the
bigger spread sheet it takes quite long ?

Best regards,

Les Stout


*** Sent via Developersdex http://www.developersdex.com ***
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Slow Calculation Vanessa Simmonds Excel Discussion (Misc queries) 1 November 24th 08 03:00 PM
worksheet very slow in calculation Deepak G New Users to Excel 4 August 22nd 08 02:12 PM
Slow Calculation JavyD Excel Worksheet Functions 2 May 16th 06 10:50 PM
Does this slow down calculation? sfrancoe Excel Discussion (Misc queries) 1 January 15th 06 03:39 PM
Slow calculation Eva Shanley[_2_] Excel Programming 0 July 2nd 04 01:20 PM


All times are GMT +1. The time now is 06:27 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"