+ Reply to Thread
Results 1 to 2 of 2

Macro to calculate a cell before this macro is run

  1. #1
    Registered User
    Join Date
    07-14-2014
    Location
    nyc
    MS-Off Ver
    2003
    Posts
    74

    Macro to calculate a cell before this macro is run

    Hello simple question

    I'm trying to include code that calculates box N1 before this part of the code is run. Box N1 is a CountA value that is drawn from another sheet that may change.

    Please Login or Register  to view this content.
    So when I click the macro, I want the n1 box to be calculated before this code is run. Thanks!

  2. #2
    Valued Forum Contributor
    Join Date
    09-21-2011
    Location
    Birmingham UK
    MS-Off Ver
    Excel 2003/7/10
    Posts
    2,188

    Re: Macro to calculate a cell before this macro is run

    range("n1").Calculate
    Hope this helps

    Sometimes its best to start at the beginning and learn VBA & Excel.

    Please dont ask me to do your work for you, I learnt from Reading books, Recording, F1 and Google and like having all of this knowledge in my head for the next time i wish to do it, or wish to tweak it.
    Available for remote consultancy work PM me

+ 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. don't calculate row using macro and move to next row if specified cell is empty
    By IrishMist1748 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-17-2014, 07:01 PM
  2. [SOLVED] Macro to send email when calculate cell reaches 0
    By ExcelFailure in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-05-2013, 05:26 AM
  3. [SOLVED] Macro to search cell for a name from a list, then use 1 of 2 formulas to calculate
    By Hobalong in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-20-2013, 11:03 AM
  4. macro to move to next row if formula in cell has nothing to calculate
    By fabrecass in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-06-2013, 10:34 AM
  5. [SOLVED] Calculate and add cell value with VBA macro
    By michaelf in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-09-2012, 06:59 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