I have two worksheets, 'Project Rank' and 'WorkOrders'.
The named range 'pick.pn' is one cell located on 'Project Rank' and the
named range 'wo' consists of several rows located on 'WorkOrders'.
The following code works fine from any worksheet in the file:

I would like to create a program that will insert a new worksheet that
contains one column for the worksheet name, the value of cell M50 and value
of cell N50.  So I will have three columns with multiple rows.  The number of
rows will equal the number of worksheets in my workbook ...

I am trying to make the back ground of a cell flash. I am trying to do this
because I have entered error messages into a cell. I have the cell where it
turns red if there is an error but I would like it to flash to help gain the
attention of the person that has entered incorrect ...

I have the following line of code that was created by the macro
recorder:
Application.Run "CHFSform98g2.xls!S6Exp"
This runs a macro in the current spreadsheet called S6Exp.  My dilema

I have a data sheet that looks something like this, with about 100,000
rows:
A     B     C     D     E     F
1     5     3     5     3     2

I want to be able to open some pdf and htm files from Outlook and from xcel.
I am using
Sub testsh()
Dim target As String

I tried adding more than one Application.onKey entries to capture up-arrow,
down-arrow, right-arrow and left-arrow keys, but, none of the procedures
associated with each of the Application.onKey entries are activated.
I tried using breakpoints and msgbox statement.

Is there a way to block all the macros, when Test.xls is opened. I dont
want users to run macro in any excel file, with Test.xls kept open.
Any help is really appreciated. Thanks in advance !
-Dileep

I need to move sheets back and forth between different workbooks, and I
have no idea how to keep the macros attached to the graphical buttons
on the sheet itself.  When I use the buttons (they have macros attached
to add new row), it searches for the old file it came from, even if ...

I am using Google on AOL to read and reply to posts in the Excel
newsgroups.  I am told that I should use a "news reader" instead, but
apparently I don't get it.  Now that Google seems to be taking over AOL
web browsing (AOL says it's using the Google Browser now), should I

my problem is as follows:
There is a piece of code in MS VB Help that says:
"Range Objects
Although a Range object can have more than one name, there’s no Names

test

I've created a calendar using a VLOOKUP which shows key meetings and
events.  I would like to colour code these, which I have done using
VBA, but I find that unless you physically go into the cell and press
return, the VBA code doesn't change the cell format.

I have a chart whose data series are deleted and re-populated. After
repopulating the data the series are all REF errors even though the new
data is the same and in the same place. So I need to write the code to
delete all the previous series so I can then re-add them through code.

I need help on VBA in XL2003 / XP Home.
I want to add a additional function to a while/do loop. I want to check by
vba the saturdays AND sundays in my calendar and mark it.
################################################################