I have an excel spreadsheet with a number of hyperlinks to files in my hard
drive which open with no problem.
I have just created a new spreadsheet with hyperlinks to files in my hard
drive but when I click on them I get the dreaded warning dong and a message

  I am getting an overflow error. Below is the code. Please help me
with the fix. I am actually comparing data of two sheets and printing
Matched/Not Matched in the  third sheet.
Sub compare()

I have noticed other vlookup codes in excel and after looking at them
have started to try and use them myself.
2 questions.
1) The codes i saw had a lot of $ signs in them. I dont use them when i

having a bit of a problem, i have got this spread sheet which looks somthing
like this
Name    03/07/2006 04/07/2006 05/07/2006 07/07/2006
Fallon         08:30:00     08:30:00      08:30:00    08:30:00       

Got a question, mostly curious, and doubting this could be done withou
Macros or similiar, but hey, I'll give it a go here, someone might kno
;)
Problem:

We are looking for an on drag event for dragging a cell/range. Is there one
as there does not seem to be many for a worksheet. If not can one be
created? If not why is this not exposed by Microsoft as clearly there is an
on drag event on a range.

Hi all, I've crossposted to three groups as I'm not sure of the best
location. Apologies if this breaches protocol.
my custom excel toolbar (office97) with macros linked to 3 buttons worked
fine in Windows NT, but a recent enterprise wide upgrade to XP has resulted

I have an XY chart and wish to assign a label to the x variable from
third column of data, is ths possible:
--
zac217

i got this work and i need the fomula to add the total of x that i hav
in that columm.
ex
a                    b  

How do I convert from:
1937.2
968.6
24215

hi ..
i am trying to create a database for some products, i am working with
multiple sheets now the problem i am facing is this ... i want to sum
up the quantities of a product of a particular month and diplay it..

I've been a bit stupid. I have about 6 columns of price data where column R
is a net selling price. I've entered these column R numbers as fixed
numbers.
This is my mistake because I've added a formula to the P column which knocks

I have a spreadsheet that has the following numbers that are entered each
time I create a comp plan for sales reps.  Those are:
Salary
Commission

I too have a list of email addresses in one column and would like to insert
all addresses into one email for a mass mailing, is it possible to do without
copy and pasting each email address in one at a time?

I just got a new computer and was setting up defaults in Excel, and I
mistakenly entered 'My Documents' in the Tools/Options/General field
for "At startup, open all files in." So when I start Excel it tries to
open EVERY file in My Domuments and I have to use Task Manager to kill