I have following custom function:
Public Function InterestCapitalisation(freq As String) As Double
Dim source As Range
Set source = Application.Caller()

Anyway of sorting the following without having the 10's show up first?
1a
1b
1c

I have a form named PickAMonth with a listbox control named lstMonthlyTabs.  
I am assigning an array to the List property which works fine, but the next
two lines cause errors...
 PickAMonth.lstMonthlyTabs.List = vaWksNames

I am trying to allow a cell to gather data from two cells and return a
numeric amount based on that data.
B1 =250
A2="sp"

I have a listbox with 7 columns.  How do i format the last 5 columns as
currency with the negative amounts in parenthesis and red?
Thanks

Is there any way to do a Print Preview with 2 pages side by side.  The
reason is I'm doing scoring for a tournament with about 90 rows (names) of
information and need to be able to present the entire workbook in one screen
shot, so that people can see which table they sit at.

Given that the user has arbitrarily scrolled up and down and right and left,
what is the address of the top, leftmost cell ?  That is, the first visible
cell in the Excel window ?

Im trying to automatically send an email and im good with everything except I
want it to come up with a command button that when selected it automatically
sends the email.
Heres my code:

How do I make it so my code runs everytime I click on a certain worksheet.
This is my code so far.
Sub TripsCopy()
Dim Trips As Integer

I have a custom ribbon with a date button, a Fund dropdown, and an import
button.
When the user clicks the "Date" button, I have an input box open in which
the user enters a date (the date is validated using VBA under the covers). I

The standard write command encloses text data within quotes.
I need to create text file file that looks lie this:
       [category]
       x = Hi

Is there a way of hiding columns in named ranges in VBA? I've got a load of
columns that I want to show and hide, but I might want to add other columns
in the worksheets later, so named ranges would make life easier.
I would have thought it was simple, but I just get an error that ...

Excel 2002 VBA newbie Q:
Looking at just one object, there is a "UserForm.Hide" but seemingly
no "UserForm.Close" method. Examples in this newsgroup seem to use
"Unload UserForm". I mean, huh?

Example: I hand enter Tue in A1. From a dated data entry I format cell C1 to
reflect the day of the week an action occurred, and abrv the format ie: Wed.
I need to compare A1 Tue to C1 Wed and get a true or false answer. This will
let me calculate the number of on time deliveries ...

When I open my workbook read-only, the macro listed below runs.   How
do I also have my custom command bar hide as well?
Sub ShowAffOnly()
Dim wsSheet As Worksheet