I have a COM written in C# that I use in Excel 2003.
Everytime I start Excel to debug the COM I get MK_E_UNAVAILABLE from my user
defined functions.
After I open a winform from the COM inside Excel the function works fine.

I have a macro trying to spell check a number of discrete ranges ( not the
whole spread sheet). The range names are passed to the spell check sub
routine which uses the following lines of code
Application.Goto Reference:=Range(Address), scroll:=True

I am trying to set a version number in the center footer on each of several
worksheets.
   Sheets(Array("Cover Sheet", "Interest Rate 1", "Interest Rate 2", _
       "Non-financed", "Disclosure WL", "Disclosure UL")).Select

i have the following pivot table;
TagName                                18-Feb      19-Feb
PS001_Pump1.Daily_Runtime    4.20    3.90
PS001_Pump1.Daily_Starts    75    76

I import data for an external source into Excel.  I sort and format the data
programatically.
This data contains some information that I need to delete.  Searching that
range by using the following:

I have a protected workbook. I had fixed a password to ensure sheet
functions protection. One of the sheet's password has been changed, is
there anyway I can recover that ? I have tried using available
software, but they are not for free for longer passwords. My password

I want a macro executed from a certain row only. Other parts of macro are
copied from knowledge base. So far so good! My knowledge of Vbasic is not
enough therefore my question to you to write one statement: IF etc....
Macro:

i am trying to put validation on a textbox in a userform. i currently have
this bit of code and it does not work. all i need is for it to except a 0 or
1 anything else would produce a message box stating that a 0 or 1 is needed.
Private Sub nailbase_Change()

I was using the following code:
Dim Tcell As Range
With ThisWorkbook.Sheets("Orders to be Submitted")
.Activate

Hope someone can help, as I seem to have got myself stuck.
I am currently trying to Conditionally Format a cell based on 4 conditions.
From code I have found on other posts, I have got most of it working.
However, the bit that doesnt work is the most important bit - Applying the

I need an Excel Add-in which can convert or translate numeric values to
words i.e. if we convert 1,000 it should be like this "One thousand only"
if anyone can make this vba code please make it happened and send it to me
I'll be really grateful to you guys.

Scenario:
Our course details are held in a single spreadsheet with a column
identifying the Curriculum Area.  For each Curriculum Area we need to publish
data from this spreadsheet on our intranet.

When i open my workbook, it asks me if i want to update automatic external
links - i thought i'd deleted them all!
How do i delete them?
(i've tried edit/links but can't see how to delete them from there.....)

A macro ends with saving the worksheet. It works for me, but but not for
other users that use my worksheet on their PC. I found my solution in the
knowledge base, but I cant find how to make it flexible.
My macro ends with:

I am building charts with non-contiguous ranges.  I have struggled
through allot with this but am stumped at getting
SeriesCollection(#).XValues to work correctly.  the different syntax I
have tried either gives me an "unable to set the xvalues property of