Objective:   -  raplace cell references with names
Question:   - Is it possible to apply all the defined names without
having to select them one by one in the Apply Names dialog box?
Thank you

I am using Excel 2003.  I have several cells using a list for data
validation and would like the drop down arrow for validation to show for
each cell all the time, whether the cell is active or not.  Is this
possible?

A couple things I can't figure on Excel 2007 (the list seems to grow each
day).  I tried to record a macro that adds a text box to an existing chart.
The text box gets added, but nothing is recorded.  Any ideas?
Also, I can't seem to add text to the text box on the chart.  It ...

Hi all, i was kindly helped with some code to compare and past by Tom
Ogilvy and wouold like to know if it could be used to to compare the two
ranges and delete entire line, if so how would i change it, i have tried
but cannot do it.

I made a quite complicated VBA program. It works so-and-so: the
functionality is OK, but
1) When I close Excel the application crashes
2) Sometimes the application hangs. I have not been able to find out

I have Excel 2002, SP-2.
If the text cell selected is big in length, the code below does not work.
Sub Trim10()
  Dim cell As Range

I have set up a code to do the following:
When the dropdown control in the spreadsheet changed
1. it will clear range F5:G20,
2. if user select "(all)", then it will perform advance filter on column V

what i need to do is delete any rows where col b = 0 or 2?
For conCat2 = 2 To iCountA
   If ActiveCell.Value = 2 Then
       ActiveCell.EntireRow.Delete

I have done this before and I have done it again.
Done a lot of coding, ran the free Smart Indenter from Office Automation and
the indenter got stuck.
Progress bar is stuck at 91 % and nil can be done. On the previous occasion

How do I determine which cell is currently highlighted?  I'm trying to
create a macro that will resort some data based on one columns value. I
have that part working, but after it's sorted i want to select the cell
that was originally selected before the macro ran.  I tried ...

In Excel XP or Excel 2003, we can add picture to worksheet from url, besides
from file. There are two functions that can do the job:
1. ActiveSheet.Pictures.Insert Filename:=strUrl
2. ActiveSheet.Shapes.AddPicture Left:=10, Top:=10, _

Me again, for another "bug" in version 2007.
With previous versions, when you created a surface plot, the format of the
legend numbers was based on the format of the number behind the grid. Very
convenient. This is not the case anymore. I discovered that on a grid based

every time compile code get error:
compile error:
procedure declaration does not match description of event or procedure
having the same name

I just starting using VS2002.  Currently in my Excel XP development, I can
use the msgbox to have it display a message.  
While I was experimenting with VS 2002 and the PIA, I was wondering how I
can cause Excel to display a msgbox instead of one from the VS 2002 code.  

If I use: =IF(Sheet2!D22,Sheet2!D22,"") in column A (with no value)
The code below works.
IfI use: =Sheet2!D22 in column A (with no value)
The code does not work.