.Need help with 2 macros:
I have a chart occupying range("A1:AG30"). I need a macro that will
paste a copy of this first chart after every two rows till 50 copies of
the chart are made down the sheet.

This is a plain EXCEL question, no VBA solutions please!
I want to say, if cell1 value= cell 2 value, then set a certain cell equal
to cell2Avlaue
If not, then if it's equal to cell 3 value, then set this certain cell equal

I have a bunch of addresses where the last word of each address needs to be
split. Eg. edgeware road london. I would like edgeware road to stay in its
cell and london to be removed and placed in the cell to the right.
A formula or vba solution would be appreciated.

I am doing a study of product costs versus revenues for a set of products at
a company.  It is a developed a "price model" which returns a product cost
based on input in three cells.  I am going to carry out a study for about
200 products.

I have created a Data Validation List where the source is being taken
from a separate worksheet. Once the worksheet is protected, the user
will select something from the Data Validation List. I have noticed that
the formula bar will display whatever the user selects and it is ...

I have a custom footer and used the date button to have it show the date,
but my boss wants it to show in a different date format, specifically:
16-Jan-07
How do I modify the "[Date]" that the button inserted in the  footer to have

Hi All...........
I have a macro that works fine, except it takes too long to
run......something like a couple of minutes.  The thing that makes it slow
is the following line.........

I am using the ROUNDUP(A1,-1) formula to round up to the next ten of the
value entered by a user into A1 i.e. 317.2 rounds up to 320. Is it
possible to automatically round up to the next 10 the value the user
enters into A1 i.e. automatically change from 317.2 to 320 once the ...

Hi Gurus,
I'm trying to find a way for Excel to lump various columns into
different named ranges based on the names or headings of the columns.
There will be five different types of columns that will repeat

I have range of cells that are the same right now, and they add up to
100:
7.142857
7.142857

I am trying to write a bit of code that changes the zoom property of a
whole work book. Rather than use an array [as there are 40+ worksheets]
I want to use 'For Each' statement like
Sub ChangeZoom55()

Code given below deletes the comments in all the cells in the
worksheets.
How to modify the code such that comments in the cell A2 and B1 of EACH
sheet is not deleted but delete all the other comments in the

I've been scouring groups for a resolution to this, but I'm
unsuccessful.  I can't get a Carriage return/line feed into an
automated email from excel.  (using office 2003)
   Set OutApp = CreateObject("Outlook.Application")

I have what I think is an easy one, but yet the solution fails me.  I
have three textboxes, 1, 2, 3.  Textbox3 is set in the propteries as
visible = false.  The code I wrote is quite basic:
if textbox2.value < textbox1.value then

I have the following line in a macro
rows("32:32")
I would like to have it so that we can vary, to, say rows("38:38"). The
value in rownumber variable i want to pass to this line