I am writing a VBA for an excel application. I have encountered some
problems regarding the multi-parameters subroutine.  Here is the simplied
code:
'*******************************************************

I have two cells that display dates.  1/25/2004 (B16) and 2/7/2004 (N22).
I want to combine the values in one cell formatted like this, "1/25/2004 -
2/7/2004".
This formula "=B16&" - "&N22" returns "38011 - 38024"

Is this possible ?
i.e.  using the example from  Excel help re: linking to a non-open source
can I use :-
=SUM('C:\Reports\[Budget.csv]Annual'!C10:C25).

I'm fairly new to writing macros, so this may be easy.  I have a macro
with defined variables from the excel worksheet.  The variable changes
as the macro is run.  For instance, when the macro begins the variable
may equal 1, but halfway through the macro (after actions have been

Looking for a good check book ledger for balancing check book. Any
suggestions as to where to look.
Thanks for any help
Jerry

I know there has been a similar question, but I was hoping that someon
could help me out.  Here is my best description of my problem.
There are two sets of variables to my problem.
The first variable can either take a value of A or N, and are i

if anyone would be willing to take a look at my workbook i would be very
grateful for any feed back and improvements made, WB is basically set up to
record overtime over a week period.
would also help if you have been following any of my posts, as im sure they

I created a custom toolbar that was in a file I put into my \Application
Data\Microsoft\Excel\XLSTART directory and now I don't need it.
I have gone into customise and flagged the toolbar to be deleted and it
disappears but the problem is it reappears every single time I restart

I am working on a spreadsheet that will compute the NPV, IRR, and MIRR of different computer
systems, as a way to analyze the investment.  But I am at a loss with regards to using Excel's
built-in functions (specifically the NPV, IRR, MIRR).  The data I have is:
System Cash Flows ...

I am looking for a way to link cells in a range from a
row on one sheet to a range in a colum on another sheet.
Is there a quick way to do this as i am attepmting to
create 25 linked pages for info sorting. thanks

I have a workbook that has several worksheets in it.
The first sheet is basically a membership roster.  It contains names, social
security numbers, membership category, how much their total dues are, and
how many paychecks their dues will be deducted out of (most are 16, but it

I have the following formula in a given worsheet called 'Master Fe'
=VLOOKUP(A2,'Re-Arrange'!$2$8000,3,FALSE)
'Re-Arrange' worksheet contains 7 columns and thousands of rows (first
column is lookup value, column 3 contains a value to be returned to 'Master

Please
I would like to know how to separate text separated by commas in
cell. For example; In a cell containing the text v1,v2,T1. i want t
write the texts "v1" , "v2" and "T1" in separate cells.

I could not find an answer before posting so here an easy
(at least on the surface) question. I have a user who
created a column with 'lastname, firstname' format and
now needs 'firstname lastname'. Short of retyping the

I am trying to Copy the entire column from one sheet in a workbook to
another sheet in the same workbook I have tried the following Code: