10 worst mistakes

  • Thread starter Thread starter Michiel van der Blonk
  • Start date Start date
I disagree with #2.

I only use names for long complex formulas. It's much easier to look at a
formula that uses cell references and tell where the referenced data can be
found. Also, you can tell what the formula does because there are already
descriptive headers near the formula that explain what the formula is for.
 
Biff, I tend to rather agree with Michiel and with you. Some formulae really
do not need range names, but many do. especially when they refer to info on
another sheet.
--
HTH

Kassie

Replace xxx with hotmail
 
It all comes down to personal preference. My preference is to use names
sparingly.

One thing that does "bug" me is long sheet names, long file names and long
paths to the file!
 
And I say Amen to that one Biff!!!!! Highly frustrating and senseless.

--
HTH

Kassie

Replace xxx with hotmail
 
Unless of course they are very long names.................. :-)

Regards
Ken..................


<snip>
 
Back
Top