Solved

Excel complaining about the Format command

Posted on 2011-03-21
2
365 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:techhound
2 Comments
 
LVL 14

Accepted Solution

by:
pteranodon72 earned 500 total points
Comment Utility
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
Comment Utility
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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Sparklines have been introduced with Excel 2010 and are a useful tool for creating small in-cell charts, used for example in dashboards. Excel 2010 offers three different types of Sparklines: Line, Column and Win/Loss. What it does not offer is a…
How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation) David Miller (dlmille) Synopsis In this article you’ll learn how to use ExcelToWord! to copy data,charts, shapes …
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.

772 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now