View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Kevin Kevin is offline
external usenet poster
 
Posts: 26
Default Curious about "$" in formulas

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