I am using Office 2003 on Windows XP.
I need some help coding a function that when supplied with a full path and
file name and the drive is a network share, it returns the equivalent drive
letter - if one is mapped - otherwise empty string; if the drive is a mapped

I have placed a command button on a spreadsheet (Sheet1).  In the click
event I call a user defined, public function that I created and placed in
the ThisWorkbook module.  When I click on the command button I get the
error:  Sub or Function not defined.

On a user form I have a listbox that I am populating by having set it's
rowsource to a range on a named range worksheet.
I have actions which are run from the userform which add or subtract entries
from this named range.  I have code which changes the named range when new

I have an Excel workbook with the contact information in it,  I need to
re-arrange it in orfder to to do some data search. The layout of the data is
in a single column as follow:
Name1           (font:Arial size:10 and Bold)

Is there a way to email more than one person in one line of code?
This is the way that I have it now:
ActiveWorkbook.SendMail Recipients:="pbanks"
And this did not work:

I would like to create a drop down box for a cell so that the user can
select one of the values listed. How can I do this?  
I am not familiar with how to do other than by using a combo box. That being
the case, how would I associated item, selected, in a combo box to a specific

For users who have a shared workbook open as Read Only.....is there a way I
can force any changes to my spreadsheet to them?  Even though my workbook is
set to refresh every 5 minutes......this does not happen for anyone who has
this open as Read Only.  

How do I write vba using vba for a chart sheet I have just created on
the fly?
I 've noticed excel gives the vbcomponent a different name to the chart
name which makes it difficult to select the correct vbproject

Say I am using a linear term such as " b * X "; where "b" is a
parameter while "X" is a variable...
Now, assume that "b" is RAND() value and assume I am using an excel
optimizer. When I run the optimizer, it complains that the problem

My problem is this; I have two worksheets (1 and 2) and on Sheet 1 I have
data about 'work in hand'.  What I would like to do is when the work data on
any one row is marked as completed is simply hit a macro button that will cut
the entire row and paste it to Sheet 2 on the next ...

In column D of my worksheet some of the cell contents have a varying number
of spaces.  How can I removed any leading spaces from those cells with VBA?
There are spaces within the cells (not leading) that I want to keep.
Example below.

I am trying to set some formatting perameters in a macro for a calendar. I
would like to base the formatting on month. For example, if the month is
January color all the day cells blue, if February red, etc.
I have only been able to get my macro to shade a range and it does it ...

How do you get Excel to record a macros using relative refernce mode?  

HELP! First time trying this, I am try an example out of a book. I'm stuck.
Do I need to have anything in the Userform Initilize?
Trying to type Employee name and their picture show up in the userform.
Thank you. Jennifer

learning VBA and Macros in Excel, so forgive my newbie-ness.
I have two button forms, each with it's own macro.
Sub Button8_Click()
   Range("J2:Q2").Select