Thread: Excel 'Proper' Formula
View Single Post
Old 03-27-2005, 04:49 PM   #3
BarTopDancer
Prepping...
 
BarTopDancer's Avatar
 
Join Date: Jan 2005
Location: Here, there, everywhere
Posts: 11,405
BarTopDancer is the epitome of coolBarTopDancer is the epitome of coolBarTopDancer is the epitome of coolBarTopDancer is the epitome of coolBarTopDancer is the epitome of coolBarTopDancer is the epitome of coolBarTopDancer is the epitome of coolBarTopDancer is the epitome of coolBarTopDancer is the epitome of coolBarTopDancer is the epitome of coolBarTopDancer is the epitome of cool
Ya, it's a huge spreadsheet. It was given to us in all CAPS which is harsh on the eyes. We're also confused as to how we're getting a circular reference.

I know I tried:

=proper(A1:E220000)
=proper(A1:A220000)
=proper (A1:E1)

I can't recall which one gave the circular reference (most likely the first), and tracing of the reference doesn't show us the error.
__________________
Spork is the new MacGyver
BarTopDancer is offline   Submit to Quotes Reply With Quote