I have a simple dynamic range name with the formulae:
  =OFFSET(Sheet1!$A$1,0,0,COUNTA(Sheet1!$A:$A),1)
When I delete cell A1 this range names becomes corrupt:
  =OFFSET(Sheet1!#REF!,0,0,COUNTA(Sheet1!$A:$A),1)

I have a workbook that opens another workbook that can be stored in any
location (however the filename will always be the same).  I have managed to
write the code to allow the user to select the location of the second
workbook. However, in the interests of completeness I have ...

I would like to be able to run a code that will check to see if a
control has a particular name and then tell me which one has that
name. I thought the code below would work but it does not do the
trick.

We are presently using Excel for linking all our Solidworks (CAD) parameter
and we need some more columns to be inserted.
Is it possible to increase the no od columns from 512? Pls mail me at
mk.vasudevan@idolafori.com

I have two excel worksheets both worksheet contain one column that have same
data. I want to bring extra column from worksheet # 2 to put side by side in
worksheet # 1 base on first column (that have same data eg Commune Name) Is
there a way to match or merge these two worksheet?

When importing my access report into excel this is the layout:
Summary of Outstanding Items:
Prj no.   Project name      Currency           Invoice Amount
--------  ----------------                              ------------------

I have a worksheet that contains student enrollment information in courses
and in some cases the same student has multiple items listed for the same
course.
The logic is as follows:

I have a master spread sheet which links to several other spread sheets.
When the other spread sheets are closed the links fails with a '#VALUE'
error. When it opens it asks if I want the links updated which I respond with
update. This only occurs with some cells. What do I need ...

Is there a way to use conditional formatting in such a way so I can highlight
cells that use a particular formula?
For example, my spreadsheet uses a lot of INDIRECT() formulas in different
variations, but I would like to highlight them all.

I was wondering if there is a way to hide rows so that they can only
be unhidden using VBA using something like veryhidden or something
like that?
I am using the top row of my sheet to create custom views by hiding/

Reading workbook properties from an XLA
Hi,
Hope you can help me on this one.
I have a Software Package that exports excel workbooks containing

I want to run a sql statement in Excel that will extract data from an Access
database.   I have found this code but have a question.  Value1, value2, etc.
are all part of an array.  How would I modify this code to use the values in
the array?  Depending on who is using it, the ...

I have a question about adding data to a named range.
I have an application that takes data from an Oracle database and writes it
to a specified Excel file starting at a column and row specified in the
command line.  I would like to change that so it writes to a named range.

Hopefully someone can help, the code below works fine for these two macros,
though there must be an easier way to achieve what I want.
What I want is to delete any rows if the criteria isnt met in column D. If
column D has either 1103 or 1203 or 1303 or 2103, then keep that column ...

Help is needed:
I have the following spreadsheet:
A          b              c             d             e
Crse1   01/08/07  08/08/07   16/08/07  23/08/07