This question has 2 parts to it.
QUESTION 1:  FIND & REPLACE (Follow-up from a previous post).
I'm using Excel 2000 and I ran into a problem when I tried making a macro
which did a find and replace on many items on an imported spreadsheet.  After

PMT() uses 360-Days Bases method to return an annuity or interest. I need
such a formula / function, which calculate interest on 365-Days bases. Can
any body help me in this respect

G'day there One and All,
    This latest query of mine will, I hope, find a more elegant method
than the one I'm now using.
    My code processes a number of strings which relate to shift

I have a worksheet containing many rows of data. What I need to be able to do
is after I update the information on the main spreadsheet, I need to be able
to create a new worksheet in my workbook for each section of data on the main
worksheet - by the way, each worksheet that is  ...

I have data in sheet4 that i need to search for by value.
I want the user to Place a Numerical value in sheet1.Range(G8)
Then Click the Forms Button to search through Column C in Sheet4 for values (>=) that value.
What would be the BEST way to FIND this value(Macro Recorder does not ...

Is it possible to create a new user form by copying an existing form?

When I try to change the color of cell from a function called from that cell, the change never takes place.
function SetMyColor (colorindex)
Application.Caller.Interior.ColorIndex = colorindex          'this line never works
If Application.Caller.Interior.ColorIndex = xlNone Then

I have a spreadsheet with some basic column headers in row 1 and data in some
cells below the headers (range is actually flexible).  After I divide up the
data into different worksheets, many of the columns are left blank except for
the headers and I'm looking for a way to search ...

I have a sheet with 40 named ranges in it.
I would like to make a "table of contents" of this sheet that would
have the name of the range in a column and in the next could the page
its on (all automatic page breaks)

I need help omitting #n/a from calculations
ie is A1 = 3, A2 = 4, A3 = #n/a and A4 = 5 and I do the calculation
min(A1:A4) i want it to come up with 3 not #n/a...
can anyone help?

can i "call" a subroutine that is held in an add-in?  all i know i can do
pertains to functions (not sub's): i can type, in a cell on a spreadsheet,
=myfuntion(a,b) and it will return c in that cell.
i want the equivalent of hitting a user-created button that i created

Is there anybody that could help me with this issue ?
I am in Montreal (Quebec) and I always use the period (.) as decimal symbol
and the comma (,) as thousands delimiter.
I have to develop Excel applications for any kind of environment, and I

Is there a way to refer to "protection" (its on/off condition), in a Macro
line?
A simple example would be -
If  "protection is off" Then Worksheets("abc").Range("a5").Value = 0

"gimme this gimme that" suggested to me in an earlier post that instead of
trying to delete modules that are protected (which i never figured out how
to do in code), just run these macros and functions that are currently in my
modules in an Add-in.  i have no idea how to do this. ...

Need help in moving column contents without overwriting existing
contents. Example - Cell A1 contents is "1234/", cell B2 is "55". Want
to move all of column B to column A without overwriting the cells in
column A. In example cell A1 would end up reading "1234/55".