Hi, I have the following code which generate a chart with three series. I'm
struggling with solving how I can set the color of the different series. So
any suggestion.
Sub addchart()

The following macro works fine in Excel 2003. Its purpose is to set the
origin of the 2 axes (x and y, with a timescale on both x and y) of a
graphe.
On my PC which is running Excel 2003, every work fine. On others PCs with

I am trying to copy and paste a list from sheet to sheet and convert the list
from vertical to horizontal. Any ideas please.

Hi, I need help with a bit of code that cycles through every Excel file in a
single folder, and copies the filename and links the last value in columns C,
E, F & G, such that I end up with a seperate Excel file showing:
Name  |   C   |   E   |   F   |   G   |

When I run my macro, the VB editor window opens up by itself. How do I
prevent this?

I've never used user forms as part of a macro.  I am trying to create a list
box in a user form but can't figure how to enter the list of months.  I have
created the user form and inserted the list box, just can't type the months
in...any answers?

1) I've used an excel spreadsheet to map out one of our warehouses.
If I say that my example warehouse has 3851 shelves (555 are empty)
one cell per client/shelf and I have 15 clients in total - I'd like t
be able to (when data is delivered) add the name of a client or indee

I have this macro to e-mail a sheet when a toolbar button is selected.
can not seem to protect the sheet that is created from the code I hav
below. Can anyone help with this problem, I am stuck!
Sub Mail_Range()

and why does this script make it happen please
Sub MergeMove()
'
' MergeMove Macro

I'm hoping to get some help with something that feels complex to me, that may
or may not be for the guru's here.  
In my worksheet I have products that, in some cases, have components as well
as a master line item.  There are two properties of the master line I need to

First post - so please be gentle!
I've a spreadsheet with a macro that works as follows:
1. the user pastes some data into B4 to Bn (variable range) and for a
fixed set of columns

I have a need to reduce the amount of text in a range of cells.  There are
certain keywords that are not necessay in the cells that if removed the text
length would be acceptable.  
How do I go about removing keywords from cell text with VBA?  This would

I have a problem with an excel file with a user function implemented in
a module, this function is used in some cells in the same workbook.
Sometimes the function correctly return VALUE (in the cell i see this),
and sometimes with the same conditions the execution is stopped and the

I'm quite new to VBA Programming, but have used many sources to figure
out what I needed to get the job done.  A lot of my problems are
format-based where I do know the logic of what I want to do but the
coding in VBA is what slows me down.

I just came across some code which uses the "#" sign.  I seems to be using it
when delcaring constants:
Const Variable1 As Integer = 10#
What is the # sign doing?  Why would you use it?