Anyone know how to get a named range to expand and contract to keep it
within dates in column A?, i have 3 named ranges on a w/s the first
spans dates 1/1/06 - 14/4/06 and the other 2 are segmented for the rest
of the year, when i insert another row/second occurance of a date in

I have a small problem and I am new to excel. I have a number of
students who come to our school. We trace the course of thier progress
in a spreadsheet. When they leave we log the withdrawal date in cell
b5. The cells B6, B7 and B8 are used to record their employment result

I use Pivot Tables (Excel 2003) to create Profit & Loss statements.
I would like to insert a custom formula to calculate 1) Gross Profit
and 2) Gross Profit %.
My pivot tables look something like this:

I have a worksheet change event for when a value is entered into cell
B2 as follows -
If Range("B2") <> "" Then
Range("A2").Value = Now()

Please help me.
I am importing two .csv files from an Oracle table into a workbook:
SalesRep, MainRep
Column A: is Bank

I use Range to insert some numbers to the sheet. All works find. But I have
one problem.
Excel converts numbers like 2.76 to 1 febrary 1976. How to avoid this?

I would like to come up with a macro to concatenate a range of cells like
A1:B3 into cell A4 (first row of range, last column of range plus one).  I
would like to add a carriage return after concatenating each row.  So in
this example A4 would be equal to =CONCATENATE(A1,A2,A3 ...

I have in the data base two adjoining horizontal cells having entries <x>
and <y>. respectively.  How to find that row.

In my, and I assume most everyone else's, SendTo folder there is an icon
that is labeled "Mail Recipient"  which it says is type MAPIMail
How can I access this function from vb and is there a way to modify the
function.  I couldn't figure out what to open it with.  If I can I ...

Please help me with the following: I have an excel sheet with data
pertaining to telcomm switch. I have a command button on the sheet. When I
click the command button it asks me for a string. I then want to open a WORD
file and search for the same string in the Word file. I want ...

One file which used to open normally, suddenly opens today but with no
visible sheets, just a gray screen.  urrgh...  I can see everything's still
there in VBE (by opening a new book, and pressing Alt+F11 to get to VBE).
The file has a couple of regular module subs (a few simple ...

I've made a function that works out that tax payable on an annual income.
However, I can't seem to find an analytical method to go backwards (i.e. work
out the gross income from the net income) without using GoalSeek.
Is there a way to implement GoalSeek automatically? Perhaps ...

I need a macro that selects the letter out of a cell address without the $
sign.
Thanks for your help in advance.
Severn

I have a Master List and I have made 4 separate worksheets for each of the
criteria fields I need to access.
WksMaster
WksA=apples

Is there anyway that i can prevent a user from launching the visual basic
editor in excel on a protected worksheet/workbook? Basically i dont want a
user to be able to see any of the vb code that is on the worksheet.