Results 1 to 3 of 3
  1. #1
    Bronze Lounger
    Join Date
    Jan 2001
    Posts
    1,418
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Manual Calculate Part Of A Worksheet (2000)

    I know how to manually calculate either a whole file or a particular worksheet. What I am looking for is a way to calculate only a selected part of a selected worksheet.
    Any ideas?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Manual Calculate Part Of A Worksheet (2000)

    You can recalculate the cells in a range using VBA:

    Worksheets("Orders").Range("D5:H36").Calculate

    or, to recalculate the currently selected range:

    Selection.Calculate

    You can create a macro (see below) and assign it to a toolbar button and/or keyboard shortcut:

    Sub RecalcSelection()
    Selection.Calculate
    End Sub

  3. #3
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Manual Calculate Part Of A Worksheet (2000)

    Hans, did not mention this, but there is one caveat to using this method (and it may be obvious)

    It only calculates and updates the selection. Excel will review the cells in the selection and look at their precedents. Any dependents of the cells in the selection will not be updated.

    If A1 has then number 3, A2 has =A1*10, and A3 has =A2+5 and you have manual calcs on:

    The values will be 3, 30, 35 for A1:A3

    If you change a1 to 4 select A2 and recalc only A2, the values will be:
    4, 40, 35 (A3 will not update).

    Also some of the precedents to the cells in the selection, may also not be updated since they could be have calcs depended on things that have changed.

    Steve

Posting Permissions

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