How can I skip this code if Cell A1 of the row below the active cell
contains a value?
     Range(.EntireRow.Columns("A").Cells(1), _
        .Offset(2, 0).EntireRow.Columns("A")).FillDown

I have a form that I load with data from a worksheet, the loading of
the data works fine, see abbreviated code below.
To perform some further evaluation I added some text and combo boxes to
the form, see code at bottom, with the selection from the combo box

I have 2 main worksheets--Students and Schedules.  With help from past
posts and replies, I've made a module that allows users to archive the
Schedules sheet, thus allowing them to compare what classes students
have had in previous quarters or semesters.  The start of the module

Is this possible to track dates of a month except Sunday by running a
macro.
Akash

I have a couple of textboxes on a vb form.  For these, I need the value
entered to be sure to be numeric.
What's the best way to check for that?
application.isnumber(txtBox.value) returns false... becauese it thinks its

I'm using Excel 97
Maybe someone can explain this to me.  I'm copying, via code,  the
contents of one cell to another cell.  The source cell contains a 16
decimal place number, and is formatted as currency with 4 decimal

I used the Macro Recorder to create the following code to generate a Pivot
Table.  When I try to run it I get the following error:  "AddFeilds method of
Pivot Table Class Failed".
Any ideas how to make this work?

Excel XP, Win XP
   Win XP has a built-in FAX capability so the user can send a FAX from his
computer.  That's what I have.  But I need to program in Excel VBA the task
of sending a range by FAX.

Need to create new worksheets from a template ws, then name them from a
list on a sheet called "CatNames".
The sub below from Dave P. works fine, except i would like to avoid
creating duplicate sheets.

I am having a problem with looping. Basically I am trying to pull one
number from a list on a separate tab, put it in a cell in template form
and save it and then take the next number in the list and populate it
in the same cell in the template. The way I'm doing it, it's saveing a

I have a workbook with a bunch of VB code in it.
I have this workbook and any other workbook open, but this workbook is
not active.  I click the X to shut down Excel.  It calls the
Workbook_BeforeClose event, then asks if I want to save my work (as it

I'm trying to create a workbook of labels using an array to fill a range of
cells A4 to P75 from a user input box or boxes. The order should be A4:A75
through to P4:P75. i.e. A4 = 1 to A75 = 72 etc. I would like to expand the
user input for text as well as numerical data, where ...

I need to be able to lock worksheets against being edited (well, and allow
sections to be editable).  This would be a trivial task, but I need to be
able to do it by manipulating the XML representation of an Excel document
(working against Excel 2003, for the record).

I wrote some code, that creates multiple charts (more than 10 or even 20).
The code works fine, but after a short while, it stops for no apparent
reason, while VBE indicates that the code is still running. If I want to stop
it, Excel quits.

I have some data like
ID     Comments
12    No-DS/ALG PCN
13    NKMA/NO DS