Here is what I wnt to do. I will use +INT(RAND()*(100-1)+1) to generate a
number but i do not wnat to use  the function key F9 to do this. Would liek a
command button to push and have ti generate the number in cell below. I do
not under stand the command buton but knwo how to get ...

I know how to use =Rand() but i need to generate numbers between 2 and 100 or
2 and 20 etc and want whole numbers not 4.6789678. How is this done
please..Brain has quit functions after being up so late.

I am using a macro (by Ron de Bruin  ---thanks Ron) which sends a Lotus  E
Mail to various people...No problem so far..
But I would like to be able to have a checkbox that will allow me to pick who
to send to, instead of hardcoding the names in as I do at the moment.

Thank you to all who replies to my previous post. It seems I had
misunderstood the problem.
(Going back to my BMX bike example)
We have the following data:

How unprotech .XLS if we dont't have password? All cells have some
formulas but it can't see or modify. How can i proceed?

I'm trying to insert a Vlookup into a cell based on variables that are
collceted via a user form.
Only problem is, for the "Else" part of the the below "If" statement I
get a "Run-time error '1004': Application-defined or object-defined

I have created Macro for Advance filter from Master sheet and put the
selected records to the other sheets. When I tested it OK, I put it in the
server, since this is excel I changed it to be sharable and I changed the
macro security level from High to Medium.

I have a spreadsheet that will have information pasted in daily from another
source.  How would I set code to automatically remove every occurance of  
"Overall Result" from Column A.  I know this is a worksheet change Event
Macro but I don't know the code to search in column A ...

I need to be able to automatic clear all cells to the right of the cell that
was changed. If anyone can help Thanks in advance.

I am trying to create a XY plotter graph for my experiment using VB
6.
My excel sheet has x1,x2,x3 data in the 1,3,5 columns and y1,y2,y3
data in the 2,4,6 columns to plot my 3 series.The first row has the

I hope someone can help me with this one. I am fairly new to working
with Access DB. I need help with creating a query which can import
CSV. files which are larger then 65,000 rows and then splitting it
into 2 files by projects, which then can be transported back to CSV

Is there any way to bring up the VBA help file without first starting
Excel?
I tried a few things last year, don't remember what I did except that
nothing worked.

Sorry this is so long, but I wanted to lay out what I have and what I
wanted...

list of records to inventory each day based on what rows they are in.

I'm having some problems with sending an e-mail using VBA in Excel.
- I only want to send some text as the e-mail message but in addition to the
text the entire worksheet is being sent.
- Even though the e-mail message is sent automatically, my Excel application

I'm wondering if there is a way to fire off a GET request and then not
wait around for the response?  The reason for this is that when I send
the request the time on the response can be quite long and it locks up
the userform until I receive the response.