Hey all, before I get a bunch of wordy opinions based on the subject line
(grin) let me tell you what I am really looking for. I am proposing a small
business app be written in Excel and in order to get the proposal approved I
need to provide a risk assessment of what doing so ...

Hi.  I've done some hunting around and reading and came up with the
following code that creates a new blank sheet and names it via a user
form, but I can't work out how to do the same thing if I want to use a
formatted template worksheet.  Please help!

Someone sent me an excel spreadsheet but there are bubbles covering
random portions and it can't be read.  The help menu only contains
undefined jargon.  How do I fix it?

I am trying to produce a spreadsheet that will be accessed by remote users,
save itself under a individual's name and then when the remote file is opened
again it searches the individual's computer for a that file, if it is there
then it is opened and the original file is opened ...

I'm building a Macro that is growing "like Topsy". At the moment it is 145
lines long, and will increase by about 50% from there when done. Because I'm
an old (really OLD<g>) VFP programmer, my thinking and development pattern is
shaped by that experience.

Hi, I've inherited a workbook which performs multiple functions and has input
cells and combo boxes on the first sheet (the first sheet serves as an input
page).  Information is entered on this input form into cells and combo boxes,
then a button is clicked to enter the info and ...

How do I call a function from the Analysis Toolpak add-in in a user
function?
Application.worksheetfunction. does not work
How do i reference a function for the Toopak add-in?

Here is my initialization of an array:
Dim shtList As Sheets
Set shtList = Worksheets(Array("Earnings Balance 2003 Q4 Page 2", _
                "Earnings Balance 2003 Q4", "Earnings Balance 2003 Q3 Page

I am a novice at writing macros and need what I hope is some easy to
obtain advice. I am trying to create a maco that will search for some
text and when it finds it will then delete the row where the text
appears and then continue searching for the same text. I have a simple

I have a scoring grid that scores upto 4 skill sets per question.  Right now
I am using a COUNTIF equation on the side to count if the scorer type in the
code for the particular skill.  I would like to simplify this by scoring the
skill if a check box is checked for the ...

I have data in a worksheet.
I have two rows between each of my lines of data.
What I need is a macro to insert a sum calculation for everything
above until the last sum calculation.  The numbers are contained in

in transferring data in these 2 sheets, the rows will always stay the
same, but the column will change..........
Private Sub CommandButton1_Click()
Dim wsRpt As Worksheet, wsCmp As Worksheet

how can i send a mail from excel using VBA.
that is, i have a program in excel (VBA) and at the end i obtain a
text file with the results.
i need to send a simple mail (TO:, SUBJECT: ) with this text info as

Dear users,
I have posted this also in microsoft.public.excel - since I really
need an expert not only in Excel but maybe also in macro programming,
I thought, I post it here, too. I was confronted with a very strange

I have number in column A
What I want to do is have a macro that can look down the column and if
the cell is bold then multiply the contents by -1 in order for me to
turn it into a negative figure.