I have an .xla that I created. How can I force Excel to load it every time
Excel 2003 opens?

I am very new with Macros but have grande expectations.
My workbook contains Template sheet that when key cells updated, summary
information auto populates lower section of Template.
I DESIRE & ENVISION

My problem is that when I start recording with a macro I use Find to navigate
through my data.  I'm using Find because I will be using different worksheets
with different data. However, the starting locations of the data points are
the same. So if I use Find "Start" and then use ...

I have a column formatted as text.  I have data that looks like this: "
through 5" or "2 through 14".  My macro does a find and replace:
Range("D2:D100").Replace _
What:=" through ", Replacement:="-"

I am trying to pull data from a ws in the same workbook, everything is ok
untill i try to create a macro that will do this automatically. The poblem is
when I try to pull a name, it gives me the cell reference instead of the
name. Please direct me in any way...

I have been using Application.Transpose function since Excel 97 first
appeared. It allows to transfer a range of cells values into Variant
array in VBA code without For ...Next loop.
Currently I have switched to Excel 2003 and uncovered that this

I've gotten some advice about how use the code below to populate ComboBox1
with letters instead of the numbers as below using the Chr() function, but I
can't make heads or tails of where to put it.  I'd appreciate any help.
Private Sub UserForm_Initialize()

How do I make a form that has 2 fields that user can define the range of
cells they want to select?  For example, if the user enter A1 in the
first field, and C3 in the second field, and press the OK button, the
cells from A1 to C3 (A1:C3) will be selected?

Is it possible to have a column of multiple values and by clicking i
the cell, it filters on that value
--
QuickLearne

What would be a good method to validate the name a workbook is saved as.
For example, I want to force the user to save a template workbook with the
words "*Air Container*" included in the name.  Note the wildcards, as each
file will have a seperate name, but must include the words ...

I just want to select a one-column-range starting at the selected cell
and stretching out until a row specified in variable x.
There has to be a better way than this:
Range(ActiveCell.Address & ":" & Left(Replace(ActiveCell.Address, "$",

I want to adapt this:
.HTMLBody = SheetToHTML(ActiveSheet)
How can i only have a selected range of cells, or a selected page sent in the body of an email instaed of the entire sheet as it currently does?
Any idea's  ??

I am a biologist, I use Excel often but am new to VBA. Essentially, I
am looking to create a macro which gleans certain data from one
worksheet and refines and deposits it into an adjacent worksheet. If
the answer to my problem is already out there, sorry, I searched and

During a long running excel macro that also sets page margins and headers, I
set the activeprinter at the start of the macro but it changes dynamically if
the system default printer changes during the macro's execution.  This causes
the macro to fail. Is there some property that ...

I am writing an add-in with a userform that needs to detect when a
change occurs (by the user) on the active worksheet.  The
Worksheet_Change event would work if I was coding in a workbook only,
but the userform can't depend on any code in the worksheet/workbook.