What would the code look like for the following:
I want to navigate to (make active) a specific cell within a name
range even if the range definition changes.
I want to (go to) or make the active cell the last cell in a name

I have a macro that adds a new addin before saving the file. This macro has
to call/invoke a sub-routine from the addin. I tried using the
application.run but looks like it doesn't work.
Any suggestions?

Gravely need some assistance to write a macro that can do the
following:
Where A1,A2,C3 etc are values (in this case, A2,B2,C2 and D2 as well as
A3,B3,C3,and D3 "belong" to A1 and A6,B6,C6 and D6 belong to A5 and a

I dont know if this is possible, but I am trying to create a menu that
remains on the screen. The menu would be situated at the right of the screen
(exactly like Clipboard). This menu would remain on the screen, but also
allow users to use the workspace in worksheets. I have tried ...

I am trying to return a DAO recordset from SQL Server so that I can use
CopyFromRecordSet to populate some data in Excel 97. The below creates the
recordset but the CopyFromRecordSet fails with :
error -2147467259 (80004005) Operation is not supported for this type of

I have created a custom control bar with dropdown menus.  For some
reason, the attached macros as soon as the cursor hovers over menus.
Is there a way to change it so that menus respond on click or on double
click instead?

I would like to lock a sheet so no information can be filled in any cells
until a certain cell has information selected. Is there a way to do that?

I tried
  local_Var  =   [Book2.xls]gb_To_Be_Read_From_Outside
from Book1.xls
I know it looks stupid, but need some way to do it, please help.

I am pretty new to this forum and have had most of my questions answere
by searching other threads.  But can't find an answer on this one.  
I have created a form for data entry and it has several list and tex
boxes.  I have used an if then statement to validate that the tex

Why, in the code below, is the for each loop executing three times?  Is there some hidden Excel thing I need to know about.
Private Sub ProcessIndividuals()
Dim myWorkbook As Excel.Workbook
Dim strPath As String

I have written an application which in part uses the flex grid control
(msflxgrd.ocx), and it appears that our PC image contains this file meaning
that anyone can open and run my application.  As there is the possibility
that this will be used by users who do not have our company ...

Hi guys.  I'm new to excel programming and I wrote a macro by Alt-F11.  Now
when I access it from the worksheet I get a #NAME exception.  This worksheet
is the 4th worksheet in the workbook if that matters.
In the editor in the obect dropdown list it says (General) and in the

I'm a volunteer who needs to take a master worksheet and then subset
into individual groups.  To keep maintance low I'd like a way to add
the new people to the master and then let the program sort it into the
subsets.  I can do some minor coding but not use to coding in excel.

Hello there, I`m trying to make a textbox that only accept numbers
including zero (0), I wrote a code, it work fine, but the only problem
is that this code
doesn`t accept zero witch is bad. Can you please send me a code that

I have an Excel worksheet that consists of several pages. I need code to
print each individual page to PDF files. I have code to print to PDF via
Adobe Distiller but cannot figure out how to extract each individual page. I
am able to count vertical page breaks using VPageBreaks ...