I am reading a book on Excel 2003 VBA programming.  It gives a short
synopsis on how to set up the code for the workbook_open macro but
doesn't really go into how to do it.  Can anyone help me with this?  I
am using Excel 2007.  I plan on writing the code on a Vista OS and

I was wondering if anyone can help with my problem.
I have a workbook containing three worksheets; 'sheet1', 'sheet2' and
'sheet3'. And;
1. On 'sheet1' I have name of the months from B5 to AO5

Hope everyone is enjoying their respective memorial day weekend.
I have a large file that I've made, and want to insert a series of rows by
vba.
I thought the following would work, but I've missed something, and I cannot

OK,
This must be something simple.  That I just don't see.
If I want to store the active workbook in a property.
I am trying the following code.  However I am getting an error on setting

I am trying to set the InputRange of a combobox on a sheet (not using a
form) via vba. I thought the following code would work, but I get a space
between the last column reference and the rownumber.
Dim i As Integer

I know I can use the Intersect function to return the address where two
ranges intersect.  The code below will equal N2:BE2 as this is where the
ranges overlap.
InterectString = Intersect(Range("N2:BE2"), Range("N2:BF2")).Address

Is there a way to create a link or button in one spreadsheet that when
clicked on will take you to specified cells in another workbook within the
same file?

I'm having trouble with Find and FindNext (I think).  I have 2 sheets with
rows of data containing ID1, ID2, and other data (in that column order).  I
want to find the row on Sheet2 that contains the same ID1 and ID2 as in a
single row on Sheet1, and mark (in a column to the ...

What is the best way to send a macro to colleagues that don't know how to
program in VBA? Until now I only made macro's for myself and just put them in
a custom menu, but that doesn't work for colleagues of course...

What I would like to do is take the follwoing data:
Inventory Tag    Item    Location    Qty
22                   H00016    770           20
100                   H00016    770    10

First, my problem occurs on this part of the code:
           nav = Sheets("facts").Range("B5").Value
           Set ie = CreateObject("InternetExplorer.Application")
           With ie

i don't get access to the secondary axis by using the excel interop in
c#
at the following code i get an error "Exception from HRESULT:
0x800A03EC" (-2146827284)

I'm using the following formula for my criteria and it doesn't work :-
=AND(D16:D1013="Mid-Term", (F16:F1013="Yes"))
D16:D1013=Mid-Term
F16:F1013=Yes

How to show a cell reference as Text:
Example:
Cell C3:  Has input of =+G12,  Shows value of 236
Cell D3: Need to "extract" the cell reference used in C3.

I can get this info via pivot table, but there has to be a way to get sum it
via a formula.  I have multiple worksheets and each has multiple rows/columns
of data.  I want to use 2 different sets of criteria (from different
worksheets) to sum multiple columns of numbers in the ...