Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #3  
Old 02-21-2014, 02:29 PM
Cosmo Cosmo is offline Error handling in formula - suppress 'Syntax Error' Windows Vista Error handling in formula - suppress 'Syntax Error' Office 2007
Competent Performer
Error handling in formula - suppress 'Syntax Error'
 
Join Date: Mar 2012
Posts: 240
Cosmo is on a distinguished road
Default

Sorry, here's the basic calculation I am using (I need to tell how many pages exist from a certain point to the end of the document):

{= {NUMPAGES} - {PAGEREF FirstSectionBreak }}

If the bookmark 'FirstSectionBreak ' is renamed, or missing, I have seen either a syntax error, or some other error. I'd like to do something like this (pseudocode):

{= {NUMPAGES} - (IF bookmarkExists{FirstSectionBreak }, {PAGEREF FirstSectionBreak }, 0 ) }
Reply With Quote
 

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Using multiple formulas in one (IF, AND and SUM) gives syntax error markdeniet Word 1 02-05-2014 05:17 AM
Error handling in formula - suppress 'Syntax Error' Automation error Unknown error" message once they open the Excel file hlina Excel 1 10-08-2013 09:14 PM
Error handling in formula - suppress 'Syntax Error' VLookup is giving me #N/A error, help with data or formula? ladygogo78 Excel 3 10-22-2012 12:28 AM
Error handling in formula - suppress 'Syntax Error' formula divide by serio error vthomeschoolmom Excel 1 04-18-2012 02:29 PM
Error handling in formula - suppress 'Syntax Error' Saveas error handling jillapass Word VBA 7 03-30-2012 03:24 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:36 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft