+ Reply to Thread
Results 1 to 4 of 4

VBA Formula unexpected behaviour

  1. #1
    Registered User
    Join Date
    03-30-2014
    Location
    UK
    MS-Off Ver
    Excel 2016
    Posts
    24

    VBA Formula unexpected behaviour

    Hi

    I had the code working which was simply VBA inserting the formula into a column and repeating to the end of the range.

    It was filling correctly but now its acting up, each cell has the correct formula inserted but now I need to manually go into each cell and press enter for it to update the formula.

    I am really puzzled to why its suddenly doing this? not sure if ive accidently edited it. Got a few codes similar to below, but at a lost and any assistance be great.

    Please Login or Register  to view this content.

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    Re: VBA Formula unexpected behaviour

    Automatic calculations ?
    Are you still using XL2003? If not please update your profile

  3. #3
    Registered User
    Join Date
    03-30-2014
    Location
    UK
    MS-Off Ver
    Excel 2016
    Posts
    24

    Re: VBA Formula unexpected behaviour

    Ah doh

    When Excel formulas are not updating automatically, most likely it's because the Calculation setting has been changed to Manual instead of Automatic. To fix this, just set the Calculation option to Automatic again. ... In Excel 2007, click Office button > Excel options > Formulas > Workbook Calculation > Automatic.

    My itchy finger must have pressed it off.

  4. #4
    Registered User
    Join Date
    03-30-2014
    Location
    UK
    MS-Off Ver
    Excel 2016
    Posts
    24

    Re: VBA Formula unexpected behaviour

    Thanks Pepe I realised this too, thanks !

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. IF returns unexpected value
    By markosvoul in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 04-03-2020, 05:12 AM
  2. [SOLVED] Help with VBA unexpected borders
    By dodde in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-11-2019, 02:22 AM
  3. [SOLVED] Removing Exact Text String from giving Excel Cells - Unexpected Behaviour
    By ghoneim in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-05-2013, 08:42 AM
  4. Unexpected (?) behaviour of OFFSET() in array formulas
    By vezerid in forum Excel General
    Replies: 11
    Last Post: 12-13-2005, 04:30 PM
  5. [SOLVED] Uh-oh, unexpected behaviour. Commandbar shows up in all workbooks and doesn't close down.
    By StargateFanFromWork in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-09-2005, 12:15 PM
  6. Unexpected result
    By Biff in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-06-2005, 02:05 AM
  7. [SOLVED] Unexpected result
    By Biff in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-06-2005, 01:05 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1