Microsoft Office Forums - View Single Post - Problems setting HeadingFormat

tfurnivall · 04-08-2014, 07:21 PM

Thanks for the feedback, Paul. I'm quoting from the help on Mid (since that seems to be where the app hiccupped for you:

Code:

Mid Function

                                                                                                                                                              This page is specific to the Visual Basic for  Applications (VBA) Language Reference for Office 2010.    Returns a Variant (String) containing a specified number of  characters from a string.
 Syntax
 Mid(string, start[,  length])
 The Mid function syntax has these named  arguments:
       Part
  Description
   string
  Required. String  expression from which characters are returned. If string  contains Null,  Null is returned.
   start
  Required; Long.  Character position in string at which the part to be taken begins.  If start is greater than the number of characters in  string, Mid returns a zero-length string  ("").
   length
  Optional; Variant (Long). Number of characters to return. If  omitted or if there are fewer than length characters in the text  (including the character at start), all characters from the  start position to the end of the string are  returned.

 Remarks
 To determine the number of characters in string, use the  Len function.

I'm using Office 2010 - how about you?

I also tried un-setting and re-setting the flag, and it still doesn't function properly. Perhaps this is a corner case on my particular environment:

XP SP3
Firefox 27.0.1
Office 2010 14.0.6129.5000

It's a trivial nit, and I can certainly use the scripts that are created, but it sure would be nice to find out exactly what is, or is not, going on!

Tony