I am linking data to a worksheet that has some values equating to 0 because
the source cell is empty.  Search and Replace for a 0 doesn't work because it
finds the formula which is not a 0.
Any help on how I can replace the 0 with a NULL via a macro in a selection

I have a problem with a listbox that is populated enough so that a
scroll bar appears.  When I scroll down the last item will not
appear.  There is still a little space left below the scroll bar
before it gets to the bottom indicating that it should scroll down one

Say I created an Add-in (lets call it Original.xla) to hold some UDFs I use
quite a lot.
Say, I have used these UDFs in Test.xls.
I now want to rename Original.xla to New.xla and then make Test.xls

Anyone have any code that can read through a selected workbook, save each
sheet to a text file (excluding header row) the code would need to append
each sheets data to that text file so the text file has all the data from the
workbook in one data file.

How to make a dropdown not accept other values not in the dropdown list?
Clara

I need to find out if the active/selected window is a particular sheet and
take action accordingly. Something like this:
If Windows("Door schedule.xls:1") = Sheets("Specs") Then
or

I find change and selectionchange are entwined together. If I want to limit
a cell' content change, I have to handle selectionchange ,change and
selectionchange orderly. Because focus first need to move to the cell, then
change the content and last focus move to other cell. Could ...

I need to let the user select ranges from other open workbooks.  The Refedit
doesn't seem to allow switiching to another workbook when it is in use.  Does
anyone know any way around this for excel 2003?

Excell 2002 SP3 - When totaling up my rows and columns I want Excel to ignore
any numbers I make red.  ( I still want to see them - just not have them
included in the totals )
Thank you,

I am using the below code and it works perfectly except for one thing.  If
there is a blank in the range "cost", but there is a value in the offset
column, it will clear that value out.  I want the code to ignore blank cells
in the range.  I tried a couple different things to no ...

I created a program in MS Excel 2003. I have protected with MS IRM (or RMS),
it seems to work but we are still in the testing stages. My question is there
a way to use programming to stop the “Shared Workspace” window from
automatically opening when the program opens and if so ...

I recently upgraded an ActiveX EXE built in VB6 that is used by a few Excel
spreadsheets.  I preserved binary compatibility when I compiled the project.
I can use the ActiveX EXE without any problems (it queries our database)
except in some cases where an existing spreadsheet that ...

I been provided with a spreadsheet of over 10,000 line of data which I need
to do a mailing for.
The only problem is, some of the lines have been coloured (cell colouring)
which requires a different type of mailing.

I want to add a separator line to isolate the new option I added to the end
of a context menu. I have not been able to find the necessary code. My code
to add the item is taken from a Microsoft example, but I'm not sure it's as
efficient as it could be:

I'm keen to learn how to write my own functions and would like to use
some microsoft functions as a starting point.
So using =ceiling(number,multiple/digit) as an example can anyone
supply the code that would be required to make this function if it