I am working on an accounting spreadsheet (income statement to be exact). I
need to put a little asterix or numbers (1 2 3) behind several of values in
the cells indicating that there is a footnote on the bottom. Now if I just
put * it assumes that it will be multiplying so does ...

im trying to write a macro that will add hyperlinks in column a of sheet 1
for 1000 rows linking them to the corresponding cells in sheet 2(ie.
hyperlink in cell a1 of sheet 1 will bring you to cell a1 of sheet 2).
however i need the hyperlinks in sheet 1 to be able to adjust ...

My personal macro workbook has several ancient macros that were
converted from Lotus 1-2-3 about 10 years ago. They show up in the
workbook as worksheets with the macro code on them. They are not in
any of the modules shown in Visual Basic Editor and there are no empty

Is there a function to return the sheet name in Excel?
Thanks,

I have a genetic sequence such as:
AATTCAGTTACTTTTGCA
I need a formula that will tell me if this cell has a run of 4 or more
consecutive letters.  The run can consist of 4 or more A, T, C, or G.

Is there a way to disable the close button top right of a userform. I am
after the user only being able to use a commandbutton titled 'Exit'

i am now trying to get the target cells of my hyperlinks to appear at the top
of the page instead of at the bottom. i know you answered this one in bill
elerdings post "execute macro after hyperlink" but i cant get it to work,
maybe because i wrote my hyperlink formulas instead ...

How can I make my standard outlook signature show when I send a workbook
from within excel?
Jim Tortorelli

Can anybody tell me what the following code does?
Set myRng=Me.Range("a3:a5,a7:a19,a22:a33")
thanks

How Can I creat OBDC file

I have a database which contains morethan 65536 rows. Pls tell me how to
open the database and pls tell me which application helps me to open more
than 65536 rows.
-Christ.

In row A I have dates 31-Jan-08, 28-Feb-08, 31-Mar-08...etc.
In row B I want an =IF function such that a certain formula will apply if
the date is 31st December, regardless of the year.
Can anyone tell me how to refer to the date in such a funtion? i.e.

Is there a way to have a note display or pop-up each time a spreadsheet is
opened?

A little help needed from the gurus.........
I need the following to happen:  
If in any row, the value in column 15 equals "trade" and the value in column
17 equals either "r" or "w", then offset(0,2).select.

Is there a way to have an email sent automatically if a value in excel
reaches a certain point?