Assuming the following is valid code, how do i code for the variable
rngWeekNum?
Worksheets("Roster").PageSetup.PrintArea = "" & rngWeekNum & """"
any help would be most gratefully received.

I've been trying to format some cells to accomdate some data in the for
of time (hh:mm).  I have tried all the time format options and trie
some of the custom format options but every time I enter some data int
the cells, its put that data into the date rather time.  How to I mak

Is there a function to convert a date into a day of the week?
e.g. A1 = 21-Mar-2004 and is formatted as a date; in B1 I want to show that
this is a Sunday.
TIA

The problem revolves around people's duty roster.
The table looks like this
    jan 1 start    jan 1 stop    jan 2 start    jan 2 stop ...
fred    8am        3pm        3pm        6pm

I am working a temporary job and trying to create an EASY to use for
for tracking training employees.  
I have a LARGE list of classes.  I have looked at handling this severa
ways:  1) Straightforward drop down list of all classes - Problem:  Th

this formula works :
=SUMIF(M!$C$13:$C$228,$D8,M!$O$13:$O$228)
i tried replacing with :
=SUMIF(m_cause_cells,$D8,m_total_time)

   I can't remember how to lock the headings across the top of the
worksheet so when I scroll down those headings remain in view.

This is very useful but we would like to be able to vary
which day is "a nn working day" ie not necessarily
saturday or sunday.
We used to be able to do this with Lotus 123, but have now

I'm back with another macro mail merge challenge. I use Microsoft Word
97 on a Windows/NT machine. I need to perform a Catalogue mail merge
using an Excel spread sheet as the data. The resulting Word merge
document needs to yield a Geographical listing containing a group of

Sir
Is there a way to calculate the "Feet-Inches" & Degree-Minuts-Second
OR
The formatting of cell for this

Can anyone tell me how to write a formula that will make a
cell self delete after a given time?

Can we do spelling and gramar check in Excel?
Thanks,
Kim-An
--

I want to share a template purchase order with others in
my office.   I want the purchase order number to change
automatically to next number each time someone opens the
forms.   Is this possible?

I have a subtotaled sheet from an external data source with only tw
columns( part#, qty) on another sheet I have my vlookup statement whic
has the part# column, how can I get the vlookup to ignore the wor
total on the subtotal page.

Hi,  I'm a "one-man" shop, using only one PC, using Excel XP.
I want to develop lists of critical dates for various projects (the list for
each project would be on its own worksheet in a workbook).  Each critical
date for each project would be in column A and the description would ...