Is it possible to set the conditional format of a cell where it will go look
to a range of cells (B2:M150) in another (open) workbook called Employee
List (on worksheet Employees) for the value of the current cell and then set
the format based on the value which in column M. I ...

Is there a way to program a worksheet to have exchanges rates
automatically updated from the Web?
/Why Tea

Hi
I want to check for some particular files (Containing some particular words
like time sheets or April/May 2006….) are already there in a folder or not.
Can I check I mean search whether the particular file is there in folder or

I could not find any Excel function for a very basic task: Calculating
the average percentile (or other) rate of change of a value between two
time periods.
Example: if in 1990 Ed weighed 100 and in 2000 Ed weighed 200, this

A friend wants the list of potential choices to be on a different worksheet
than where he is choosing the value, via data, validation, list.  I told him
to merely echo that list onto the current worksheet but he thinks that is
too inelegant!

I am a beginner to visual basic and need to write a macro to swap between two
workbooks without mentioning any filenames. Can anyone help?

I'm have an active sheet with data in it. Also, there is a chart1 tab
which let user to see the graph of calculated data. How can I enable
and disable the chart tab in lower-left part of the screen?
It must be disable as long as the sheet is not puplated with data.

I have a variable (Columnname) that finds a column where a Cell in a
row equals a value on another page.(A user inserts a date on the first
page and it matches a value in a row on another page and this variable
is set to that column) The problem I am having now is using it to set

Hi: Can any one please tell me how to i create a lookup sheet. I mean
every time when i open the excel file it automatically update the data
into the sheet from another excel file.
Thanks.

Hi: Can any one please tell me how to i modify the sumif3D code so that
it will accept the file name too. I try it to pass 4th argument in it
but it shows no error and no value. I copied this formula from
http://www.j-walk.com/ss/excel/eee/eee003.txt

Hi: Can any one please tell me how to i create a lookup in one sheet so
that every time when file1 is open it goes into file2 and copy the
values from the sheet of file2.
Thanks.

HOW CAN I CHANGE THE FONT PROPERTIES SUCH AS BOLD TEXT SIZE USING VBA.
I ALSO NEED TO INDIVIDUALY CHANGE ONE OF THE TEXT COLORS TO BE
DIFFERENT FORM ALL THE REST. ALSO I NEED TO KNOW HOW TO HAVE TEXT THAT
APPEARS IN THE COMBOBOX ALL THE TIME BEFORE YOU CLICK THE CHOICE YOU

situation: i have an excel spreadsheet that i'm trying to manipulate
data from(multiple columns).  I'm trying to use activecells, but am not
quite sure how to utilise multiple active cells.  here is the basic
idea of my code......

Ok we all know that I can select a sheet on Excel by doing:
sheets("Name").select or worksheets("Name").select
But my problem is that I take the name from a cell with something like:
Dim Name as String

Hi,  I'm working with multiple rows of data, probably around 3000 rows
and I have the word "total" in between the data in Column A in Excel. I
want to add three blank rows after the word Total. The word Total is
also in bold font. Can someone please help with a macro? Thanks.