I have the following UDF which works when I call it from the debug window
but not on a sheet.
Any ideas?
Public Function GetRole(sRole As String) As Long

I have a spreadsheet that contains all the parts that me manufacture and the
process times for each operation to make these parts.  The process times are
in minutes per piece.
What I am wanting to do is calulate the start day for each operation by

Hi everbody,
I tried to compress pictures with a makro. If I do manually, format
graphic --> compress --> web/monitor 96 dpi, it works, but when I
record this with the makro recorder and play it, it doesen't work.

How do I write code to perform a simple sheet selection based upon a listbox
box selection?
My listbox equals a range in an excel sheet.
Once the user has selected the relevant item in the list the cell link the

Is it possible to detect programicably
if a certain font is installed ?
I did consider checking the Font folder
and if the font name exists, assume it is present

I wish to compare a list of cells as follows:
          A                       B
1      Abc                      ABC
2      MIAMI                   Miami

I have a bunch of cells, say A1 thru A50,
each of which is occupied by a text string, such as...
    New York     or
    chicago        or

Hi I would like to do the following in VBA .
1>create   3 data validation lists
2>make the second one dependent on first
3>make the third one dependent on second

For example, I have 3 cells across by one row down and the first two contain
data that is separated by Ctrl + Enter:
Column:                    A              B               D
Row:

I want to use check boxes to select certain rows in the spreadsheet to
be transferred to the database.  After these check boxes are selected,
I then want to use one "update" button to transfer to the database.
Currently, as you select each checkbox that row individually is

I have a a spreadsheet that has filters on it.  I want to be able to itterate
through a range that is selected using the worksheet's change event.
The target range might be $e200,$e300,$e500:$e510
I want to be able to do something like

This is a dumb question I know.
When I'm recording, I often gets things like the following below.  Is it only the last line that matters?  If not, what was the equivalent shorter way to write this?  I'm embarrassed to let someone see 50 lines of code that could be done with one ...

May I know what causes "Not enough system resources to display completely"
dialog box error?
This dialog box appears frequently in Excel 97 and not in Excel 2000.
Regards,

I have to run SUM from the last day of the month to A5 for column A and
B5 for coulmn B(I have 2 column in which I type data) The code I have
here does the job, but only if you actually open the sheet at type
somthing that day. If I don't type in anything that day, then it does

I cannot find a link that my workbook says it has by searching each spreadsheet.  Would it detect a link when opening the file, if I had inadvertently assigned a macro in that other file to a button in this file?  If so, is there some quick way to check to where all my buttons' ...