The dollar signs don't matter -- unless or until you copy the formula
to another cell. Use a dollar sign before a row or column to keep it
from changing. When editing your formula, you can press F4 to cycle
through the four possible combinations.

I couldn't find anything about it in Excel or VBA help.

Jeez, it's only seven levels deep. What have you been doing all day?

Help
Microsoft Excel Help
Table of Contents
Working with Data
Formulas
Creating Formulas
About Formulas
The difference between relative and absolute references <----
Thar she blows!


- David