All i need is to calculate a correlation of two ranges and assign it to a
variable. I tried this but i get an 91 error (object or with block not set):
dim correlation as range
Set correlation.Formula = "=correl(inSerie" & i & ",inSerie" & j & ")"

I need to execute some code from an add-in within the Workbook_SheetChange
event.  As part of this I need a global array that I can update/use from
within an add-in UDF and this workbook event.
When I define a global array in an add-in module, I can update it via the

I have a static array, AI2:AI37 that holds a list of department numbers that
I compare to another column of department numbers.  The code below checks to
see if the department in cell AI42 matches the deparment in cell AI2.  If it
does, change the value to 'MATCH TO DEPARTMENT' ...

When using this function : Selection.PasteSpecial
Paste:=xlValues,Operation:=xlNone, SkipBlanks:= _
  False, Transpose:=False
How do I change it to past a Public Constant?

I have Excel 2003 macro but have a customer who still uses Excel 2000.  Is
there a way in Excel 2003 to run the macro that simulates the Excel 2000
environment?  My customer previously tried to run the macro but received an
error message.

I am trying to create a pie chart that reflects the total percentages from
multiple worksheets, data from indentical and specific sales?

I'm looking to change the color of numbers based on the text beside the column.
Then I need to sum up the values based on those colors.
I started things by using a Conditional Format, but that won't work. I
believe I have the code for the rest of this project though.

When using this VB function :
If StrComp(Target.Offset(0, -3).Text, "Debit", vbTextCompare) = 0 Then
How do I turn it into a numeric test?

hi,
I have a formula in cell A2 that references D2.  like "=D2". D2 happens to
be part of a pivot table (a grand total).  how can I make sure that the cel
reference follows or "chases" when the size of the pivot table decreases or

Guys,
3rd post on this now, and I have narrowed my problem down to this:
Function  test () as String
test = "line1" & vbLf & "line2"

I'm still new to this, but I'm looking at WMI to maybe do this. (Please
correct me if I should just use .net to do this.)
I'm looking at a 'report file' in Excel, I can either CSV it or keep it in
the same format.

Does anybody know of any ways to organize the VB Editor?  I have quite
a few subroutines and my editor is getting pretty long.  In VB.NET,
you can create "regions" that allow you to group conceptually similar
subroutines together and then collapse them when you are not currently

I have a fairly large Excel spreadsheet with a small VBA program that
conducts a simulation using the spreadsheets as a calculation engine.  A
number of results are obtained from each simulation run which are stored in a
table.  The sheet includes a result summary area which ...

I'd like to put a pivot table on a seperate sheet from the data in MS-Excel
2003.  What would the code look like?

I have inherited an excel file filled to the brim with obsolete name
definitions, numbering in the hundreds.
I would like a macro that loops through these names, see where they refer
to, and if they refer to any #REF!, or a particular external file that no