I need a macro to copy the first cell in a row down the column until it runs
into a existing value and then copy that value down until it meets another
existing value and then copy that value down the column and so on.

I have a sheet (PAS) that has a type of calender to track the number of hours
I work at part-time job.  Here is the set up of calender:
B125:B176 = date for beginning of week (which is a Monday) (52 rows ie weeks)
C125:G176 = columns for Mon Tue Wed Thur Fri for 52 weeks

Using MSOffice 2003
I have a ws named lists. Col A has my list that I am using in the data
validation technique to get drop boxes on my working spreadsheet. It is
working well as is, but I want the user to be able to add to the list.

Greetings.  I am seeking feedback from the group on the a project handed to
me. What I have is a situation in which there is an xml file updating a table
in SQL Server 2005 4 times per minute.  What I am faced with is getting the
info out of sql following the update and placing ...

I have problem accessing some of the help in VBA. When I press F1 in Visual
Basic editor window, the help panel will show up at the right side of my
screen, and there are three main entries listed: Microsoft Excel Visual Basic
Reference, Microsoft Visual Basic Documentation, and ...

  I'm not very knowledgeable on codes and all that intails.  What I'm
trying to do with Microsoft Excel is create a spreadsheet using data
validation.  I've gotten that part complete.  Now what i'm trying to
do is add a "Clear" button so that the drop down data validation cells/

Using MSOffice2003
On my spreadsheet, I want to do this:
If C15.value > 0 then D15.value = 65
Then I want to copy this down these two rows.

I can not get this line working, it will be assigned to a named range
 Statetotal = "{=sum(if(Month(" & worksheets(shname.range("a2:" & rc & ")"
_
               & "= month(" & Rmonth & ","

The code below is in a userform.
MyText appears in the correct format.
However, when run, I get the <<error9, out of range error message>>
If I substiute ...Worksheets(MyText)... with ...Worksheets(6)... it runs.

I have columnar data in the four headings below;
        A                        B                             C            
      D
Loan Number / Taxpayer ID Number /  Customer Name /  SCR21

I am having trouble executing a macro.  I get the following error:
COMPILE ERROR:   Sub or Function not defined
(Location of error noted below in 2nd macro.)
Can someone tell me what I need to do?  Below are two macros I am using with

I've searched all over and cannot find an example of coding that will close
all open user forms.  I'm thinking something like
   For i = 1 To Controls("msforms").Count
       Unload ?

The active cell holds file(s) path(s) separated by ";".
I'm splitting the content of the cell, if it is not a valid file name I'd
like to delete that element. Is the deletion part doable? THANKS IN ADVANCE
When I use GetOpenFilename the extension of .doc files become .docx.

I want to write the following code:
dim s as variant   ' or as string
dim x as double   ' or as variant
s = "1+2+3"

I've a spreadsheet of inventory information that was exported from
QuickBooks. The resulting spreadsheet contains a number of rows with no
information in the column I want to sort on, so I would like to
automatically delete those rows. I'm totally new to writing VBA for Excel,