Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Excel complaining about the Format command

Posted on 2011-03-21
2
Medium Priority
?
378 Views
Last Modified: 2012-08-14
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
0
Comment
Question by:James Cochrane
2 Comments
 
LVL 14

Accepted Solution

by:
pteranodon72 earned 2000 total points
ID: 35183917
That is the symptom of having a bad reference declaration in your project. One bad reference throws off code that is unrelated to the problem library. In the erroring file, go to the code module and look at the references declared. Are any of them listed as missing? Clear that one (or those ones), close and save, and then add them back in (but only if they are necessary). Please write back if you have not added / removed References before and I can be more specific.

Hope this helps,
pT72
0
 
LVL 6

Expert Comment

by:FernandoFernandes
ID: 35192417
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)
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

916 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question