I'm trying to round a date to the first day of the next (14 day) pay cycle to
show when vacation time is accrued.  Right now, I have:
- In cell B6 I manually enter the Date of Hire
- To show when benefits start, 6 months after the date of hire (or 3 months

My boss built a macro which returns different results when run than
when he steps through it.
Before I get specific about what the macro does (since I don't have it
in front of me), I thought I'd ask the general question about what

Here's an odd question.  I have a macro that reads the contents of a column
into an array.  The size of the cell contents can vary, and sometimes exceeds
255 characters.  Sometimes, the array data is truncated to 255 characters,
other times it is not.  

Which one is better (safer) way to do:
1.
   If moExcelApp.Workbooks.Count > 0 Then  'when any sheet is opened
       Set moExcelWS = moExcelApp.ActiveWorkbook.ActiveSheet

Is there a way to find out the default number formats for Excel?  For
example, if you open the "Format Cells" dialog box (Menu Bar: Format /
Cells, or Ctrl+1), click the "Number" page, and select "Date", the
"Type:" box populates with a number of options.  I'm asking if there

I need to find a way to identify all the people who have a dollar
amount of 250 or more in two of five columns.
Name          Amount1       Amount2        Amount3
Amount4           Amount5          True/False

I was wondering if anyone knows a way to determine which of the "OR"
occurrences triggers the "Error" result.  Basically I want to either create a
pop-up box (which I know how to do), or change the font color to alert the
user to an input mistake.

I need a macro to insert two rows at every 6th row.  
Thank you.

Potrbujem zadat v office 2007 SK znak "∑" Ako?

I have the following formulae =HYPERLINK("mailto:"&J2,A2)
which creates a working hyperlink.
Problem is I need to move this data to another spreadsheet - If I copy
and paste values it looses the hyperlinking abilities...

I am doing Excel Automation and I notice that when I close the Excel window
launched from my main form, EXCEL.EXE still remains in my Task Manager. I
have a cleanup routine in my main form which kills the Excel process when my
main form is closed. But, I would like the ability to ...

Hi. How can I set the font size and rows height for entire sheet?
Greetings

hi all. I've got the following situation: I have a column with operations and
a next one containg the time they occured (time format 00:00:00), what I want
is to determine a standart time interval for every occurence, eg: 08:15:12
should result 08:00 - 09:00 and so on, with 1 ...

I am trying to create a user form that will display a selectable list of
available modules within a VBAproject in excel.
How do I return a list of modules?
Thanks

Yesterday I asked about how to create a UDF resulting in an array (one or two
dimensional).
Thanks for the big help, Chip, Dick and Gary''s Student!!
Now I know how to create a UDF returning arrays (one or two dimensional),