I am using  Excel (Excel 2003 on Windows XP) to track due dates that are
based on a certain event date  (e.g. 30days, 100days, 120days, and 180days
from the event date) and had no problem determining each due date by formula.
The due dates appear in columns N,O,P,Q, the event ...

I have this code
With Sheet1.Range(Runinfo1.ComboBox2.Value)
If .Range("b2") <> "" And .Range("b7") = "" And OptionButton2.Value = True
Then

I created a straight forward VBA function in the VBA Editor that sums  
miscellaneous values in my spreadsheet.  I tested it by using a message  
box to display the answer and it works fine.  How do I get it to run in my  
spreadsheet?  I tried just putting it in a cell prefixed ...

I have a query in Vlookup. I have created two columns in col A which
has numbers from 11-21 and col. B Jan-Nov and is using
Vlookup(D3,Date1,1) with value with D3 as Jul it is returning #N/A. I
want to retrieve the value of the first column based on the second

I defined a pulldown data-validation menu in Sheet3.
I put a reference to it in Sheet1, and it worked OK. I put a reference to it
in Sheet2, and it failed, telling me it evaluates to an error.  Formatting of
relevant cells is identical, sheet & workbook protection is (currently) ...

I have a Word document where someone who didn't know the value of mail merge
keyed in all 200 labels by hand.  They each have 2 lines per label and 30
labels per page.  I would like to "reverse merge" and import the data from
these labesl into an excel spreadsheet.  Haven't been ...

I have a spreadsheet that has multiple tabs.  I want to have a row of data be
linked to a column on the other tab.  For example:
A1 linked to A1
B1 linked to A2

In excel I want to change the unit of measure cm to inches. It's in the size
tab of the format picture

Does anyone know how to create a spreadsheet with more than 1 vertical
split?

I'm using Excel 2007 and this should be simple but I'm stuck. I have a
column of seconds and I want to see them formated as hh:mm:ss but when I do
the time format I get something that isn't correct. I've tried the TEXT,
CONVERT and several other.

I followed the directions as listed under CLR's post, however I am unable to
figure out how to copy down the column as well.

Here's what I'd like to do: I'd like to type 41507 in a cell, and have it
display as "4/15/07" or "04/17/07". Instead, it pops up some crazy date like
7/31/85.
I've figured out why this is (the number indicates which day since January

Excel 2003
I have a series of cells using a Named Range for a data validation list.  
Until yesterday it worked fine.  Now it doesn't work.  The cell, list, range
is all the same.  I've done the Edit/Goto/Special/Data Validation/All and it

I have a userform that i created in VBE on excel but i don't know how to make
a macro on the actual document to take me from it to the form or make a
button from the form take me back to the document, could anyone give me an
answer, it's for my coursework and i need some help! ...

We have a user where I work who has Excel 2003 on her computer.
She is complaining that on certain excel documents which she has used
in the past that when she goes to save them after making changes, she
gets the error message: