Greetings --
I have one workbook that pulls reference data from another.  I want many
users around the country to have their 'client' workbooks, opening up the
'source' workbook with the reference data stored centrally.  That way, I only

Why does this not work please. It is suppose to produce a list several
lines long but only produces 1 line.
 For cmb = 1 To P
   tly = 0

I need help with getting the proper columns in a pivot table.
To simplify things, I have this type of data
Todd   300
Todd   100

Hello all.  
I had a question as to how to perform a certain task.  I know how to record
a Macro, but am not really sure how to get the results I want if possible.
Here's the situation:

I am trying to update an old XLM macro.  
Eventually-I'll redo it.  But for now, does anyone know the command to
unprotect a protected sheet?
Thanks...

in an sheet I created fot a client I applied an automated autofilter that
checks for some things. The client uses Excel  2000. I developed the system
in 2003. Everything works fine in 2000 but one thing is curious.
The three commandbuttons that start the VBA application are erased ...

I am trying to copy a row from one sheet based on a certain criteria and then
copy it to another sheet.  The below code works fine, but it take quite a
while to run through a couple thousand rows.  I am trying to write the code
to just paste the row in the correct spot from the ...

I have a grocery list that I have calculations on show total, but need to
break down calculations by dept and would like this to show on sheet two
because sheet one I convert from an order to an invoice and down want break
down to show.

How can I get my pointer to change to a hand when it is over a command button?

I'm getting an error message when the following line attempts to execute:
x = CountIf(Worksheets(Sheet1Name).Range("H" & Sheet1RowPointer & ":U" &
Sheet1RowPointer), ">0")
Sheet1Name is Dim'd as String.  Sheet1RowPointer is "Dim'd as Integer.

Ik have an Excel 2003 Addin with several Macro's. One of the macro's
should start if I open an existing workbook. The only way I know is to
create a template with an event which call the macro from the AddIn.
This has two disadvantages

I have some code that adds a cells comments to the cell value as below:
Sub CommentsToCells()
Dim cl As Range
Dim rng As Range

I have a workbook in which users dump in data, run a macro and use the
result.  The macro itself works great, but the users need to go the original
data to confirm that the totals still match.  
Here is the process:

Can anyone tell me why doesn't work:
Range(Sheets("Word Analysis").Range("A2"), Sheets("KeyWord
Analysis").Range("A2").End(xlDown)).EntireRow.Select
when this does:

Can someone tell me what is wrong with this?
   With Selection.QueryTable
       .Connection = Array(Array( _
       "ODBC;DSN=Commerce