I seem to be running into the 1004 error on what I thought would be
something simple.  I have created 4 names
one of which is "Clothing", it refers to cells B4 to B8.  I want to
simply place the arrData into each of the five cells.

I have a spreadsheet that contains Artist, Song and Length of Song info that
was created by a music collection software. EXAMPLE CELLS 1 shows the cell's
actual values and EXAMPLE CELLS 2 shows how it looks.
I'm looking for a way to actually convert all of the song length values ...

I have two columns which copy to the new book rounded to the nearest dollar.
None of the other columns are doing this.  It should be to 2 decimal places.
CAMDepMade is long
Sub NuSaveCAMDepMade(TenRow, CAMDepMade)

I have a 2 command buttons on a userform.  cmbCalculate and cmbAddToQuote.  
cmbCalculate has code that confirms all textboxes have data before
calculating a price.  cmbAddToQuote adds the price to a worksheet.  How can I
pass a variable value from cmbCalculate code to ...

Thanks.
***

How can I test a cell for a Name, "activecell.name".
In my code below, it will generate an error if a cell is clicked that has no
".Name".
(Option Explicit assumed)

 I'm fairly new to VBA programming.  I'm using Excel 2003.  I need to
know when a particular cell (it's actually a single cell "range" called
MYRANGE) has changed.  When I detect the change, I need to see if the
new numeric value in that cell is not zero; if it's non-zero then I ...

I need some sort of loop rRoutine which will copy the current row down 1 row
at a time until it reaches row 4000

I am trying to excercise a loop.  I have a series of copy and paste commands
that I want to exercise if cells(i,1) is any of 9 text values (Cos, DL, MRB,
Swap, Finishing, DST2,Fin-T,Pre-T,Trap).
Is there an easy way to do those either than 9 "IF" statements?

Hi, using Excel 2000.
I want to ensure that a file with the code isn't saved in error or during
testing.  The code below saves the active workbook which works the majority
of times but has on occasion, saved the file with the code.  I have set up a

I have two command buttons in a userform; cmbCalculate & cmbAddToQuote.  
cmbCalculate when clicked calculates a price.  cmbAddToQuote adds the price
to the worksheet.  In order to calculate a price the user must enter all
valid information into the userform, if not a message box ...

I got this code from this NG, I do not remember the authors name, but thanks
any how because it works quite well.
I am failing to find a way to make this macro ignore all characters within
brackets "()".

It's always funny how the most basic problems are the hardest to
figure out.
I need a macro to go to the first row of a colum when a user selects a
cell below.

Hey all,
I am trying to label a couple of text boxes that are grouped together within
a rectangle.
    ActiveChart.Shapes("Group 29").Select

Hi Gentleman.
I have a form that has the blue title bar along with the "X" in the upper
right corner.
I am having trouble finding the code or process of eliminating the "X" so