I have the following situation:
I'm trying to key off of the agent ID in Column A and based on todays
day of the week return the start time of the agent from column D.  I
can index it to get me the start time, but don't know how to formulate

In Eric Carter's blog he makes this statement: ".. Excel does not support or
recommend writing an XLL that uses managed code."
Does this mean that I can but probably should not use managed code to write
a function that can be called from Excel?  

Can any one explain to me why this code will not run on any row beyond row
99?
I get the following error msg:  "activecell row out of range or no list row
selected"

I got this working but I want to do this with all sheets in the workbook.
With Application
       CalcMode = .Calculation
       .Calculation = xlCalculationManual

Many record in the worksheet1,you can see below:
     Date           Products    Price
  2008-02-02      ABC          34
  2008-02-03      ABC          36

Hi again,
I hope everyone is keeping well.
I'm wondering if there is any way to disable or remove the X button on the
top right of a UserForm?

I have a button that my users can push that will display a message box that
is linked to a cell with a percent value in it. My problem is that when the
user presses the button the msgbox say:
The value of column x is: .158765224

We have developed a listing of inventory items with a cell associated with
each item that indicates if it is present.  Is it possible to have the items
not present to be exported or listed on a different form or worksheet.

Hi agin! :)
The user of my workbook has to save the old version as 'Myworkbook2 in the
specified folder before running my upgrade, and I need to check that they
have befre running the procedure.

I inherited a workbook that has 2 sheets.  It takes TOO LONG to open, save
and even locks up the computer sometimes.  There are 2 sheets involved.  The
first sheet is named BudgetCost, and the second is named CostAnalysis.  The
purpose of the work book is to have CostAnalysis ...

Good morning all-
I have a quick question for you concerning a selecting an item out of a
listbox, allowing another userform pop up.  In listbox1, I have 51 line
items, with a SelectButton and a CancelButton.  What would be a good code for

I have a weekly status spreadsheet. Each week, I create a new sheet
with Monday's date on it. Then put in the necessary fields and
formatting. I'm writing a macro to do this (talk about lazy!). If I
have a sheet named "Mar 17", how can I use that to create a sheet

When, with this,
STaxRate = Application.Round(TTax / SubTotal, 7)
While in code the number is rounded to 7 digits but when posted to a cell in
worksheet it's stored at 16 digits.

I am trying to count the number of  unique entries over a group of columns.
For instance, I have the following in a spreadsheet:
    A
    B