+ Reply to Thread
Results 1 to 2 of 2

Other method for .formula

  1. 10-10-2014, 12:41 AM #1
    krazyhype19
    krazyhype19 is offline
    Forum Contributor
    Join Date
    09-09-2012
    Location
    Manila,Philippines
    MS-Off Ver
    Excel 2003
    Posts
    153

    Other method for .formula

    Hi,

    I have a code where I paste a formula to a large number of rows that keeps my macro run very slow... How will I revise this code for my macro to run faster. The other seems to works fast but this one really my problem...

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  2. 10-10-2014, 09:51 AM #2
    judgeh59
    judgeh59 is offline
    Forum Expert judgeh59's Avatar
    Join Date
    02-07-2013
    Location
    Boise, Idaho
    MS-Off Ver
    Excel 2016
    Posts
    2,310

    Re: Other method for .formula

    you could turn the auto calculation off when set the cells and then turn it back on

    Please Login or Register  to view this content.
    Ernest

    Please consider adding a * if I helped

    Nothing drives me crazy - I'm always close enough to walk....
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Depreciation formula as per WDV method
    By sourabhjain in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 08-15-2014, 11:03 AM
  2. Excel 2007 : What method or formula should I use?
    By Youkai in forum Excel General
    Replies: 2
    Last Post: 06-17-2009, 09:05 AM
  3. GetObject method not work after Call Shell Method
    By ben in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 02-21-2006, 11:50 AM
  4. Why QUIT method doesn't work after COPY method?
    By surotkin in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-26-2005, 11:32 AM
  5. Need a left pad formula method
    By quartz in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-06-2005, 08:06 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1