I've a big complex Excel worksheet; when I open this, I can see a message
which ask me if I want to refresh values from others worksheets.
My question: how can I find in my worksheet which are these cells linket to
others worksheets?

After, for example,
If Not Intersect(Target, Range("J1:J20")) Is Nothing Then
Do stuff
End if

I have in cell B2 "BLACKWHITE".
In cell C2 i have a 4 digit product code eg "BWCT" which will contain
letters in above.
In cell D2 i have the formula to rehash the code in C2.

Hi, Using XL2002 and Windows 2000
If I have a file named A00015249CR.csv and I want to
place the first 11 characters of the filename in a cell, how
would I do that, if it's possible.

I have two sheets:
Sheet1
Sheet2
In Sheet1 i have 12 coulmns. Out of which few are as mentioned below:

Is there a way to protect certain cells or ranges on a worksheet and leave
the rest unprotected.  There are certain ares that I don't want users to
change but want to allow them access to others.  Can you please provide an
example.  

how can I change a repeating number?
this is what I have so far.
Thank you!
Private Sub Worksheet_SelectionChange(ByVal Target As Range)

No question here, just a procedure example for the achive.
Find duplicate range or cell references (as precedents) in a cell's
formula - an example
Sub FormulaDuplicateRefCheck()

I have noticed lately that with some of my applications whenever I make a
change to code using the Code Editor the execution speed drops tremendously.  
If I save the very same changes, and then exit Excel altogether and then
restart Excel, the speed of execution is normal.

My attempt doesn't work:
If Columns("B:B") = "A" And Columns("N:N") = "manual Calc" Then
Columns("O:O") = "0"
I need it to see if column B has value "A" in it with a matching row of

I am having problems with a spreadsheet I am creating. The spreadsheet looks
something like this.
 Average     Most Recent
             2004           2005           2006         2007       all data

I copied my personal.xls from my desktop to my laptop, and when I go to run
a macro I get the "error in loading DLL" message.
Any suggestions?
Thanks

I am looking for a VBA programmer for a fee-based project. If anyone is
interested in what could be a large project, using Excel 2003/XP please post
reply and I will elaborate.
Thanks.

I have a macro that copies elements of a Template worksheet to create
new sheets. The new sheets are for the most part identical except that
the data values are different.  I need to copy a chart that is on the
template sheet to the other sheets and have it pick up the same

I want to enter a combination text/cell value in a cell, but vba won't let
me. It expects the end of the statement.  Example:  Range("A5").Formula = _
"=Summary of "&Q1&" manual comparison."
... where Range("Q1") could be "Current" or "MTD".