I am trying to record a macro that I can use with Advent Axys to change the
chart attributes in that program. When I try running the marco, I get a "run
time error 1004 - unable to set the invertifnegative property of the series
class" error message.

This pertains to behavior in Excel in the Microsoft Office Professiona
2003 when using the Excel 2007 SDK.
Background
============================

Put formula into col. S as long as same row in col J has something in it.
Range("S2").Select
   x = ActiveCell.Row
   Do While Cells(x, 10).Value <> ""

Does anyone know how to do this?
It compares whatever is in Col. A in this case "sam" and "Tom" with any
matches in Col. A of compare sheet and if it finds one, it will copy and
paste the corresponding cells from master sheet into compare sheet. Now in

I manage a few add-ins for my company.  I want to create an add-in
that runs everytime excel is opened to check if the user is using the
most current version and if not then update.
I'd like to create some code as an Add-in to be run under the

Each month I make a workbook with multiple worksheets, each day has
one or two tabs(worksheets), so that they are not numbered in a
logical series.
And on a summary tab, I do several calculations from the other tabs

I want to create three user defined functions
1. FirstName
2. MiddleInitial
3. LastName

I have a CommandButton on a worksheet from the Toolbars>Control
Toolbox.  I need it to change colors when I click on it.
Using the macro recorder, the button shows up as a Shape.  However the
recorder did not record the actual color changing that I hopped it

Hi, I currently am using an array formula to match up certain values, if they
match, then I pull a Qty value from that row.  I want to be able to have one
of those value types come from a list of numbers, I call Ncodes.  To simply
how the data looks I've created a short version.

I'm smart enough to create a macro in excel using the record function.  I now
want to send that macro to a smarter person to expand my work/project.  I'm
not smart enough to even find the macros I created to be able to attach them
to an e-mail to send to someone.

I have a macro that will prompt me with boxes and create a list of numbers
but I am looking for a way to get the macro to put the values into every
other cell.  Any help would be great!  
Here’s what I have so far:

Hi all, i recorded a macro to make a basic bar chart and selected it to show
the data label value, but it does not show it when i run the macro.
Any assistance will be appreciated.

Can someone tell me if there's a way I can access versions of files in a
SharePoint Document library?

A worksheet contains data as follows:
Column A   ColumnnB
Country1       $B$24:$B$30
Country2       $B$9:$B$18

First, thank you for looking at this post.
I have a macro that takes the cell comments from other sheets and creates a
summary sheet showing all of them. I'm constantly adding to the main sheets
and running this macro but every time I do I have to first delete the sheet