How can insert or add a number (always the same e. 1) at right side of
70.000 ISBN book numbers automatically?
Public Librarian Ask to you...

I need help in writing a code in Excel to run a macro that will
generate sequential numbers. The sequential numbers will start based on
a predefined list of already used numbers that cannot be used again (as
shown below ). The sequential number string will be  determined by the

The following method fails on 2003 but runs ok on 2000.  
activechart.export filename:=myfilename, filtername:="GIF"
I get a runtime 1004 error: method export of object chart failed
thanks,

Is there someone that can help me with my budget for the year 2007. I have
about 200 items in my budget and the breakdown is per month. What I need to
do is to breakdown every item per Weekday. Sample of my budget:
     Month Item Quantity  Value

I am working with 2 worksheets using the Index/Match function, but I
would also like to utilize the IF function in conjunction with that but
I am having problems. Here is what it looks like
Worksheet 1

I'm trying to copy some contents of two sheets into a new workbook to
be saved on the user's desktop and attached to an email.  Ron's
send mail codes (http://www.rondebruin.nl/sendmail.htm) work great, but
I must get rid of all code behind the sheets in the new wbook.  I have

when clicking insert-->name--> define the define name window is displayed.
i have a lot of cells names.
do any one know of a simple way of seaching in the list ? (not the scroll
option) typeing is not working...

I have a procedure A which calls a procedure B. Now, in case an happens
an error happens in Procedure B I want to exit the whole VBA (I want
even the Produre A should stop running).
If I simply put On error Exit Sub in Procedure B, the program exists B

I have an Excel application with all the forms/controls background
color set to ButtonFace (system color). I have a logo in a PNG format
(with background color transparent) that I need to put on the form. But
ImageControl does not support PNG and the other types (BMP; JPG) don't

i m creating dynamic list boxes in excel sheet. now on the selection of the
item of the list box i want to pouplate cells in the same row.
how can i do it?
jigs D

I have 50,000 rows of 12 values in each column. I am looking for low
outliers, so I use MIN across each row and get the lowest value in each
group of 12 values.  From there I calculate the mean, then the SD, and
get a Z score for each row.

I would like to select a range starting from cell A1, but the ending cell
can be any cell on the worksheet. I am not sure how to program this. Can
anyone advise?
Thanks in advance!

Hi I want to know if somebdy can help me VBA code for inactivating a
button if the value of a particular cell say C1 is blank.
Example: On Sheet1 have a button "knowledge" and on clicking this
button a sheet2 opens which have two buttons K1 and K2. I want if value

How to protect a range of cells in an excel 2003 worksheet? User cannot
edit the data. But, s/he can highlight those protected cells?
Please give me some suggestions.
Thanks

Ok I have had a look arround, and nothing seems to be what i need, and
what seems like i need doesnt make sense.
What I require is code so that if an entry that is put into a combo box
is not in the "rowsource" list then I would like a message box to