Thanks to Gord Dibben, Jim May and David Hilberg.
It's a funny thing David, I never thought to look 7 levels deep. Silly me.
Thanks again to all.
-Kevin

"Kevin" wrote in message
...
Dear NG:

I'm curious about the purpose of the "$" in formulas when referring to
cells.
For example Sheet1!$A$1
I couldn't find anything about it in Excel or VBA help.
Are there advantages or disadvantages to using the "$"?
Should it be used always or are there times when it should not be used?
Just curious.

Thanks,
-Kevin