I'm trying to change the background color of a cell based on a value,
however instead of using the syntax below can you refer to a cell with
a value instead of hardcoding the value in the macro?  If you can,
then what is the syntax?  thank you in advance

I have a data range with merged cells and other cells not merged in a
spreadsheet. I want to find only the merged cells so I can store a lookup
function in them using visual basic. My problem is I can't figure out either
how to enter the function in the merged cells only and stop ...

Looking for some help,
I have Multiple Sheets all named with people names
I have a master sheet with this formula
=IF($A2="","",VLOOKUP($C$1,Bozo!$D$14:$K$236,8,FALSE))

I have copied data from several excel sheets to a summary sheet, but
it contains data that I don't want included.  On the summary sheet, I
would like to copy only the rows of data that do not include a zero in
column K of that row over to another area of that sheet.  This area

It has been a very long time since I have programmed in Excel.  I've got the
general idea, but I'm missing something.
Here's the situation:
I have a information in 2 columns A and B

I've got an excel file that, through code attached to a userform, it imports
data from a text file, cleans that data up, sorts that data, removes some of
it, and exports that data (via the worksheet to which it was imported) and a
couple of other worksheets to a new file, saves ...

Column A has been sorted with a blank line after each unique entry.  I
would like to format the first occurence in Column A as well as Column
B with a background color.  Column B will continue with that color
until Column A has a different value, then a new color will be applied

I have a big excel model which does some analysis.
I have to run the model on approx 150 different values and analyze the
results.
I need help to automate this process.

I have a worksheet with names in the first row and I used a look up formula
to gather data from another sheet that signifies dates (this ties in with the
rest of my workbook and how it behaves so has to remain this way) so
basically I have columns with 1's and 2's in them otherwise ...

I am building a production schedule UserForm, which has 15 departments, and
by each department label I included a DTPicker Control.  This way my users
can select the due of each department for a particular product.  My question
is this,  is there a way to clear the out the date ...

I'm trying to copy the values from one worksheet to another and I'm
finding that the values that are displayed are what's copied, rather
than the full value in the cell.  How do I get the entire value?
Also, does anyone know the status of the Microsoft interface.

I have this macro which works great.
But I need to ALSO copy/paste the format of the cells
Sub Macro1()
   Sheets("Sheet1").Rows("1:1").Copy

I have the following code works perfect when I have a dynamic row. The
variants Dayhour and k are calculated resultls from some conditions. This
piece of code copy the dynamic row from column C. The number of cells copied
is Dayhour.

Hi...
I am developing a application in Excel 2003 with userforms, that
requires a Range to be copied from external other excel file to a
specified sheet on the coding file. i tried using Inputbox(type 8) and

Given a sheet containing many command buttons, how can I find the
macros/subroutines associated with those buttons? (i want to do it in
vba code, rather than right click each button and select "assign
macro") Thanks a lot.