I have attempted to create a column insertion macro that dynamically copies
a static value of 'Active' into all the rows in the range.  To this end,
during recording, I move to the column to the left and use an END-DOWN.
However, when I replay the macro, it copies the values to ...

Hi, just wondering how I can count the number of times a month occurs
within a column.
Example
Date

I have data as follows
Column A - Date (daily basis)
Column B - Qty
Column A spans more than 300 rows (dates) now.

I am doing my accounts in an excell spreadshee and want to add the coloumn of
figures where my income is.  How do I do it. Normally I would go to formula
and just say add, but it does not work the smae on my home computer. Thank
you. Dxx

Is it possible to refer to only certain cells in a named range. ie. I
want to use in a formula the 2nd cell in a named column range, how do I
reference it in the formula?

I am trying to use a countif function to count the number of
occurrences of a specific phrase within a column of data:
=COUNTIF(<column>,"*text*")
The problem I am encountering is that the countif function stops

I'm using excel to just added to columns. I don't know the values of the
coulmns yet but obviously i know the formula. How do i input the formula
without the result showing as zero before the data has been input.

Hello Group,
I hope someone will be able to help. I need a formula that can check each
cell in column "D"  and if it has over 8 characters in the cell, return a
value of the word LAN in column "F". Anything with 8 or under should remain

How can I print formulas and values togheter froma excel worksheet?

How can I get my main contact page to be the first page I see when outlooked
is opened?
Thanks

I have a sheet with various formattings (background and text colored,
large and small texts, borders etc.).
When I copy and paste it into another sheet I get the text only and all
formattings are lost.

Is it possible to delete fixed rows or columns in Excel.
Thanks in advance.
Regards,
Arjun

I opened an Excel '97 template containing macro's in Excel 2003 .
I removed all macro's from menu Extra | Macro's and saved it.
But still when opening this template a macro warning asks
[Disable macro's] [Enable macro's] [Help]

I created a named range called HarvestData.
In the refers to box I typed the following:
=OFFSET(Harvest!$A$2,0,0,COUNTA(Harvest!$A:$A),COUNTA(Harvest!$1:$1))
I hit ok.

The following formula is in a cell in a worksheet called MODEL.  It
pulls data from the named range HarvestData.  Problem is, if I add a
column before "M" in the named range HarvestData, effectively moving
data from M to N, my lookup formula obviously no longer works.  Does