When I try to alhabetize aan excell sheet I am working on, it says all merged
cells must be the same size. How is this overcome?
DG
--

I have a macro that changes the color in certain cells based on the result in
a particular cell.  My question is this:  can I have it run automatically
based on any new value in that cell or am I forced to run it with a toolbar.  
I would prefer that it be done automatically.  ...

Can we define a date format in  a cell to restrict only dates with certain
formats can be entered.
Thanks for your help in advance.
Dev

Always have problems with the error handlers in my macros.
The macro below opens a file then does some other stuff to it but the
error handler does not seem to work and i still get an error if the
file is missing (error 1004 to be precise)

I'm working with coloring some reports and have been trying to define
colors (via enum) for them.
1) Why is it that RGB(a,b,c) ends up being in BGR order as HEX?
Example:

All looking for a way to select cells A1-A4, copy and transpose to cells B1
etc, then walk down to cell A5 thru A8, copy & transpose to cell B5, etc.
and continue thru the workshett.
TIA!

  I'm trying to create a Simple Moving Average coloum with "N" days
data. Is it possible enter the varible in a cell and have excel
calculate the moving average with the cells N value?
   In other words, is it possible to create a S.M.A coloum where you

Ive seen numerous examples using a file directory to get file paths etc. But
I was wondering if there is  code that will build a spreadsheet that lists
just the different folders and subfolders on a particular drive that the user
chooses.  Any help would be appreciated.

I am using excel to display a large amount of data (>10,000 lines)
that is exported from a c# program. What i am trying to do is to
colour in alternate rows to make this data easier to read.
I currently have a function that iterates through each alternate row

I have a Macro that cleans down a report then moves on to filter out a list
of data for a date period using Autofiltering,
I have included the following to be prompted for the date to be filtered,
however it never filters on the date I input, I need to use an put method as

I have inherited a spreadsheet that contains a macro and I do not know
how to use it. Could some body please explain it to me.
What I believe it should do is copy cells from  "sheet1"  to update
cells in "sheet2". To expand on this a little more sheet1 has 3

  I am in need of getting Excel to lock the current windows account
so as the end user is required to type in their user name and password
to regain access to windows. The desired result can not be achived by
SendKeys for whatever reason. I need Excel to do the following...

How can I do this with or without Macro/VB code?
I want to create a Gantt Chart like graphic by coloring a grid (columns 1-52
weeks, rows dictated by number of Projects). The Design task would be colored
red, Install Hardware blue etc. Each project would have 1 row (only) where

Excel HELP seems to indicate that the maximum number of IF statements in a
formula is seven.  I have successfully designed formulas with 12 IF
statements.  I am wondering just what the limits are?
I have written a formula exceeded the limits on the number of characters in

I have a macro which sends an email based on the values from one
workbook,
What I want the macro to do is to send the email to the person whose
userid is located in Users.... which is in another workbook