getFooter-UDF-r1.xls

<div>
After a small tweak to Dave's solution - you can return all three of them in a single call:<br />
<br />
Function getFooter()<br />
<br />
&nbsp; &nbsp; 'On Error GoTo errHandler<br />
&nbsp; &nbsp; <br />
&nbsp; &nbsp; getFooter = &quot;&quot;<br />
&nbsp; &nbsp; <br />
&nbsp; &nbsp; getFooter = ActiveSheet.PageSetup.Left<wbr />Footer &amp;&nbsp;&quot; &quot;&nbsp;&amp; _<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ActiveSheet.PageSetup.Cent<wbr />erFooter &amp;&nbsp;&quot; &quot;&nbsp;&amp; _<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ActiveSheet.PageSetup.Righ<wbr />tFooter<br />
&nbsp; &nbsp; <br />
&nbsp; &nbsp; getFooter = Trim(getFooter)<br />
&nbsp; &nbsp; <br />
&nbsp; &nbsp; Exit Function<br />
&nbsp; &nbsp; <br />
errHandler:<br />
&nbsp; &nbsp; getFooter = &quot;&quot;<br />
End Function<br />

</div>


After a small tweak to Dave's solution - you can return all three of them in a single call:

Function getFooter()

    'On Error GoTo errHandler
   
    getFooter = ""
   
    getFooter = ActiveSheet.PageSetup.LeftFooter & " " & _
                ActiveSheet.PageSetup.CenterFooter & " " & _
                ActiveSheet.PageSetup.RightFooter
   
    getFooter = Trim(getFooter)
   
    Exit Function
   
errHandler:
    getFooter = ""
End Function


<div>
Not exactly what I am looking for. But I have found a different solution. <br />
<br />
Thanks guys
</div>


Not exactly what I am looking for. But I have found a different solution.

Thanks guys

<div>
That's great. &nbsp;Please share your other solution.<br />
<br />
Dave
</div>


That's great.  Please share your other solution.

Dave

<div>
<div class="content wysiwyg-content">
The footnote contain information. Is there a formular that will pull the footnote?<br />
<br />
<br />
Example: if the footnote said Boat 234, the formular would pick this up in a cell that is written with a formular. 
</div>
</div>


The footnote contain information. Is there a formular that will pull the footnote?


Example: if the footnote said Boat 234, the formular would pick this up in a cell that is written with a formular. 

Excel Formular to pull Footer

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.