|
OfficeTips Home || VBA Section || General Section || Download Section || Privacy Policy |
Troubleshooting a Long Formula |
|
If you create a long worksheet
formula that is not returning the expected result, you can drag the
pointer to select part of the formula in the formula bar, and then press
F9. When you do this, only the selected portion of the formula is
evaluated.
Important If you press ENTER, that part of your formula is lost, so be sure to press ESC instead. However, if you mistakenly press ENTER, try pressing CTRL+Z to undo the change. |
Copyright 1999-2022 (c) Shyam Pillai. All rights reserved.