Formula selecting first 1400 rows of column, need ALL of it. HELP!!

Okay when I evaluate a formula in an Excel file, I find this within the
formula when I step-in to it: "PRO!$C$2:$C$1400"

Basically, PRO is the name of the sheet in the workbook and I want to select
Column C. Now Column C is MUCH MUCH longer than 1400 rows. I can't get in
to fix this to make it say like 10,400. What can I do??