I am trying to have Excel work like Word for text writing without using
WrapText. My project is to activate à short VBA procedure each time the user
presses the space bar so that there is an automatic line change whenever the
number of characters reach a certain limit.

Hi NG,
how can I detect the address of a userdefined function within the code
of the function?
look at this example-function:

I have several worksheets that i need to print off.
But since i can add more sheets to this workbook,
i want to be able to print off all the sheets (not by name) except for about
3 sheets i can name.

I am using the calendar code
From Ron de Bruin's site:
http://www.rondebruin.nl/calendar.htm
Unfortunately, my form is a copy of a paper form and therefore has many

I'm imorting a TXT file into 2 columns where the no. of rows is not known.  
The 2nd column has numeric values.  I'd like to write a macro that replaces
the values in Col 2 to formulas based on the value in Col 1 such that the
formula in Col2 becomes the imported Col 2 value ...

i have one chart on each sheet. i record a macro to copy chart from one
sheet to other. when i run the macro...it's taking a while to
copy....will you please help me to make it faster. my other problem is
to paste the chart at specific x,y or at say B5. how can i do that...

I want to have a pop up window appear that the user can input more
information into it and then transfer that information to another location in
the spreadsheet.
In my worksheet I have the user input a name in cell A1.  When this name is

Been on my Sumproduct syntax problem for nearly 3 hours till I hit
below.(Jan 8 2005 4:08 am )
Thank you very much Dave.
Sub testIt2()

Hi all,
I am trying to set up a VBA version of a Solver model, which works fine in
"worksheet mode". The Solver has to iterate over two separate ranges. When
using the recorded macro the input values are: ByChange:=

Is there a way to modify Excel's Function Arguments box?
(Select Insert/Function, select a function and click OK -- this opens
the Function Arguments box)
By Modify I mean:  Create a Function description, and argument

Not sure why the code below does not work. It woks fine if I use
Me.Range("A2:A301").Value = Me.Range("B2:B301").Value  But I need the
returned value to be limited to only the first 15 characters. When I run the
code below, no value is placed into column A.

Note the 3rd line of code from the end where
I instruct my code to copy my entire sheet1 in order
To paste it to a newly created sheet (NewSheet)
Why does a new workbook get created with the copy?

In sheetA (A1-P30) I have data. I want to copy some data from this sheet to
sheet2. Condiotions: macro must look in column B for a specific value and in
column P as well. Rows that have both values (textbox1 and textbox2 of my
userform) must be copied. Can someone help?

I want to create a drop down box on say Sheet 1 in Cell B2 that will give me
the option of choosing four different people.  Then when I choose one of the
four people, columns B6:B12 and B15 will automatically be filled in with the
people associated with one of the four people I ...

im a bit stuck on how to write a macro that can stop a calculation for
the next date once its past a stop date.  Example:
stop date: 03-JAN-2007
ive already written an IF statement that calculates the next due date