Help,
   I have a Large workbook running multiple Macros to import, compare
and generate reports.
The Problem is that after all is said and done I endup with a workseet

Hi;
1) For neatness and memory's sake: Is it possible to change the Index order
of a collection of objects.  For example, in a project that I have just
finished I have a number of worksheets (which I refer to by name -- so I am

THanks very much, this macro creates all the right page breaks except the
first one.
The first row dept doesn't need a pagebreak above it.  So I tried to add an
ANd if to the conditional.  And if it is the first row then don't do the

I have one worksheet with all my cells having the proper width and
height... Also I have about 100 worksheets that are identical to the
1st one except the information that goes in cells. What I need is a way
to automaticlly adjust all other worksheets so they are all the same as

I need to take column E and append it to it's own row in column D,
like this, creating a new column F:
R1CD                   R1CE                R1CF
122 Main St         New York           122 Main St, New York

Hi;
Is there a way, preferrably using macros / VBA, to change the action of
Hyperlinks?
Right now, some of my users find that if they inadvertently click once on a

How do you restrict a cell so that only certain data can be entered?
For example: I need to protect a cell in a fashion that only a date can
be entered.
I'm having problems with people entering formulas in for the date and I

currently am using code:
Dim intMaterial As Integer
Dim strMaterial As String
strMaterial = ActiveCell.Offset([0], [-15])

i'm working on a larger macro & am having trouble w/this section
specifically.  i've got it almost done but am getting a "run-time error
1004... autofill method of Range class failed" error........
  Startcell.AutoFill Destination:=InsRngTmp, Type:=xlFillDefault

I have an excel spreadsheet that takes a date in cell b1 (1/25/206) and ads
7days to it (the new date becomes 2/1/2006) and ecords the new date in cell
b2.  What I want to do is if the new value in (ie 2/1/2006) is in a differnt
monththan te originating date then cell b2 woould ...

I have a pivot table that shows a list of people in the row field and a list
of dates in the column field (across the top)  and a piece of information in
the data field.
I need to be able to insert a formula in a column immedietly to the left of

Dear Anyone,
I have an Excel file which I have prepared to sell to a company. But that
company may copy and give it to another company to use. Naturally, I don’t
want that to happen. If the second company wants it, they should buy it from

currently am using code:
Dim intMaterial As Integer
Dim strMaterial As String
strMaterial = ActiveCell.Offset([0], [-15])

I have about 40 pages worth of code that checks a collection of data files
for various complex exception conditions. It is giving a false alarm on one
of them, but only when I let it run. When I step through the code as it
processes the data row that gets flagged as an error when ...

I recorded a macro to open a text-type file (.rev extension) and then save
it as an xls workbook.  It works well.  But I have a question regarding the
conversion.
The macro recorded