Solved

Excel complaining about the Format command

Posted on 2011-03-21
2
368 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
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

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

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

Suggested Solutions

Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
Approximate matching with VLOOKUP and MATCH seems to me to be a greatly under-used technique, and one which is vital for getting good performance out of large lookups. Until recently I would always have advised using an exact match for simplicity an…
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…

776 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