I have figured out the userform to create a disclaimer and it pops up when I
open the workbook but how do I get the work book to open/close according to
the selection they make. Right now it only closes via the cross, and the
option buttons in the user form don't do anything.

I would the number in cell "a3" to increase by 1 for each page printed.
In addition, it should also save the last number to continue the next
time I open the file.
Thx

Is there a way to determine the last row where a chart object finishes
As I am trying to set a dynamic printing area and my chart change
height dependant on the data criteria.
TI

I know this is possible but do not know how to make it.
I have two options in a Cell as Applicable and Not Applicable.   This
is in a Drop-down menu and what I want is that when I choose
Applicable,  it should bring up additional 5 or 6 cells for me to

Dears,
I just created a UDF (with 4 parameters) which can return a value.
Moreover, I code in the SheetChange event (after this UDF being fired) and
change the last parameter in this UDF cell to another value, however, the UDF

I've got a thesis riding on this, so any help would be REALL
appreciated!
I've got some experimental data in an Excel file with two columns: On
with words and one with numbers.

I have the following formula in every cell in my "A" column:
=IF(NOT(ISBLANK(B1)),COUNTA(B$1:B1),"")
This serves the purpose so that whenever I type something in column B, it
will auto number the entries consecutively.  When i delete a row, the

Hi have a named range with 10 rows...
I want to mark/hide the last 3 rows of this range depending on a cell
value...
anyone know how to do this?

i have created a dynamic NAMED range for columns of data on Sheet1.
PTA=OFFSET(Sheet1!$A$1,0,0,COUNTA(Sheet1!$A:$A),COUNTA(Sheet1!$1:$1))
I am trying to get the range address of the Named Range, into a single
cell say, A655536...

Obi-Wan Kenobi (without the force)
I have several questions and would greatly appreciate if anyone coul
help me on answering some or all of my queries. I am building
customer list and need help on the following.

Hi I am new to macros..
Is it possible to use a macro to create graphs?
Like, do i mark the data i want to use and then record a macro?
greatful for advice..

I need to run a macro that will search a range for a value. (I can do
that) and then return the cell within the range that the value appears
in.  I don't know how to do that.  Then, I need to be able to use the
letter and number for the cell as a value. Is this possible?

In an Excel workbook I created a multiplechoice test. On the first sheet
they select the test. On the second sheet they make the questions. The
questions are in cells The possible answers are in Optionbuttons
(OLEControls).

I am using the VBA DatePart Function as a function in Excel:
Function DatePartFunction(qualfier As String, rng As Date)
DatePartFunction = DatePart(qualfier, rng)
End Function

Can I expand the standard library of auto shapes?