Storing formula's in an array, calculating SUM in the array then
returning result into a cell without formula. this basically does the
calculation however the formula is in the cell
so far i have .......

I am using Excel to keep track of shifts.  I have three sh.ts and each are at
different times.  I need a macro that will look through one column of start
times and determines which shift (A, B, C) to put in another column.

Tom, Jim and other experts with VB,
Given below is the code (written by Tom) that highlights the area of
intersection of two cells (merged or single).
For example, if the merged cells B4 (formed by merging B4 to B9) and H2

I have a text file with space between words which i need to covert to
comma-delimited which i can convert to excel
ANALOG2:TIC3601 REACTOR 1 10 216
ANALOG2:TIC3601 REACTOR 2 30 216

I was given the following code yesterday by Tom Ogilvy to select a text
randomly from a list of cells in a message box.
Sub Text()
   Set rng = Sheets("sheet2").Range("A1:A5")

Hello Again,
I did not get a response the first time I posted this question.  The
first time that has happened.  Perhaps it is more difficult than I
think.

Is it possible to have a macro that creat a new sheet and puts it first in
the workbook like this:
I have one sheet named: kvartal1
The macro creats a sheet named kvartal2. If I run it again it creats

For some reason I lost all newsgroup items posted from 10/7 thru 12:51pm
today.  One of which was mine....I've tried downloading all and I don't get
anything....
Anyway, here's what I need.

Hi, i have a command button in a sheet to copy the sheet in the same
book with a correlative name, and deleting the cells named "variables"
(so the original sheet keeps on being the same one (It has 260 cells in
a column, this values go in the same sheet to a unique row from which

I'd like to create an event tracker.  When I have an event on a certain
date, I'd like to be able to have a calendar of some sort with a link to the
event info.  Then, whenever someone asks me if I have a certain date
available, I can click on that date to show me what is going ...

I have put a number of Shapes on my worksheet using VBA.  Now I need to
select all the shapes on the worksheet.  TIA, James

I am wanting to create a statement that will look at the employees number of
years that they are working, and then look at their grade level, and then
determine the number of vacation days they are warranted.
I have tried the basic =IF(AND(C16<=9, T16=1), "10", "0")+IF(AND....

Does anyone know how to do the above? Or have a piece of visual basic code
that i could adapt to do this?

I created a time card program and need some advice on how to calc ot...
any HR progammers out there???
If 1.5 is paid for all hours after 8 and all hours after 40 then...
if a person works 9 hours on monday (1 hr ot ( @1.5)) and 8 hours Tues

I am totally new to excel and there is a requirement that i fill 2
columns in the excel by connecting to Oracle as an external data source
and query and get the values for that record and fill the excel.
I have no clue how to go about it please can anyone help me how to go