<div>
a way to work around it, is using the full name of the function... like:<br />
<br />
vba.format(blah blah blah)<br />
<br />
instead of only <br />
<br />
format(blah blah blah)
</div>


a way to work around it, is using the full name of the function... like:

vba.format(blah blah blah)

instead of only

format(blah blah blah)

<div>
<div class="content wysiwyg-content">
I am trying out a spreadsheet on a totally different computer. &nbsp;It has a VBA subroutine that is complaining with a compiler error about the Format() function is not found. &nbsp;Yet when I create a brand new spreadsheet and create a VBA subroutine the Format command shows up in the Intellisense and it works when I run it. &nbsp;I am using Excel version 2002. &nbsp;Thanks
</div>
</div>


I am trying out a spreadsheet on a totally different computer.  It has a VBA subroutine that is complaining with a compiler error about the Format() function is not found.  Yet when I create a brand new spreadsheet and create a VBA subroutine the Format command shows up in the Intellisense and it works when I run it.  I am using Excel version 2002.  Thanks

Excel complaining about the Format command

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