• Visitors can check out the Forum FAQ by clicking this link. You have to register before you can post: click the REGISTER link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. View our Forum Privacy Policy.
  • Want to receive the latest contracting news and advice straight to your inbox? Sign up to the ContractorUK newsletter here. Every sign up will also be entered into a draw to WIN £100 Amazon vouchers!

Excel - replicate f9+shift+ctrl+alt

Collapse
X
  •  
  • Filter
  • Time
  • Show
Clear All
new posts

    Excel - replicate f9+shift+ctrl+alt

    Anyone know how to do this for the workbook programmatically.

    I need to refresh formula dependencies and then re calc...

    i know there are some excel monkeys out there!

    K
    --------------------------------------------------------------------------------

    SA - Is it like a dragons nostril?

    #2
    found it

    app.CalculateFullRebuild


    thanks all

    --------------------------------------------------------------------------------

    SA - Is it like a dragons nostril?

    Comment


      #3
      Nvm
      Last edited by Spacecadet; 11 May 2007, 10:19.
      Coffee's for closers

      Comment

      Working...
      X