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

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??

You could post the formula!

--JP

On Sep 20, 5:40*pm, Jennifer C. Jennifer
wrote:
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??

.. "PRO!$C$2:$C$1400"
.. I can't get in to fix this to make it say like 10,400.

One guess is that it is a multi-cell array formula. Click on any formula
cell within the range, press CTRL + "/" key to select the full extent of the
range. Edit it to the new range within the formula bar, then press
CTRL+SHIFT+ENTER to re-confirm it.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:18,000 Files:359 Subscribers:56
xdemechanik
---

Sorry... I didn't think I needed to.

Here's the formula that's in the formula bar: =SUMIF(cat_col,$A157,debit_col)

When I evaluate the formula and then Step in at "cat_col" it expands to
this: "PRO!$C$2:$C$1400"

"JP" wrote:

You could post the formula!

--JP

On Sep 20, 5:40 pm, Jennifer C. Jennifer
wrote:
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??

Thanks Max, unless I did it wrong it didn't work. I'm trying to select ALL
of Column C but even when I try to do that or just select the column it
doesn't work.

"Max" wrote:

.. "PRO!$C$2:$C$1400"
.. I can't get in to fix this to make it say like 10,400.

One guess is that it is a multi-cell array formula. Click on any formula
cell within the range, press CTRL + "/" key to select the full extent of the
range. Edit it to the new range within the formula bar, then press
CTRL+SHIFT+ENTER to re-confirm it.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:18,000 Files:359 Subscribers:56
xdemechanik
---

Hi,
Not sure I understand, but here's a suggestion. "cat_col" seems to be a
named range, representing "PRO!$C$2:$C$1400"
Is it just a matter of redefining this named range to "PRO!$C$2:$C$10000" ?
Regards - Dave.

Here's the formula that's in the formula bar: =SUMIF(cat_col,$A157,debit_col)

When I evaluate the formula and then Step in at "cat_col" it expands to
this: "PRO!$C$2:$C$1400"

My earlier guess on your scenario was incorrect

From your clarification in the other branch:
=SUMIF(cat_col,$A157,debit_col)

To edit the 2 defined ranges: cat_col & debit_col,
just click Insert Name Define (options are there)
Select say: cat_col in the dialog box,
then you can edit the "Refers to" part of it (eg extend the range)
Click Add, then repeat for debit_col
Click OK when done
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:18,000 Files:359 Subscribers:56
xdemechanik
---
"Jennifer C." wrote:
Thanks Max, unless I did it wrong it didn't work. I'm trying to select ALL
of Column C but even when I try to do that or just select the column it
doesn't work.

Those are names that are pointing to hard coded ranges. Edit the names
and you can change the definition.

Press Ctrl-F3 and select each name. You'll see the definition in the
Refers To box. Just click inside and press F2 to move around. You can
adjust your range there.

--JP


On Sep 20, 11:29*pm, Jennifer C.
wrote:
Sorry... *I didn't think I needed to. *

Here's the formula that's in the formula bar: =SUMIF(cat_col,$A157,debit_col)

When I evaluate the formula and then Step in at "cat_col" it expands to
this: "PRO!$C$2:$C$1400"



"JP" wrote:
You could post the formula!

--JP

On Sep 20, 5:40 pm, Jennifer C. Jennifer
wrote:
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??- Hide quoted text -

- Show quoted text -

THANKS JP, I didn't need to do Ctrl F3, I just needed to go into the Name
Manager (I believe that may be a new feature in 2007).

THANKS AGAIN FOR YOUR HELP!!!

Jennifer

"JP" wrote:

Those are names that are pointing to hard coded ranges. Edit the names
and you can change the definition.

Press Ctrl-F3 and select each name. You'll see the definition in the
Refers To box. Just click inside and press F2 to move around. You can
adjust your range there.

--JP


On Sep 20, 11:29 pm, Jennifer C.
wrote:
Sorry... I didn't think I needed to.

Here's the formula that's in the formula bar: =SUMIF(cat_col,$A157,debit_col)

When I evaluate the formula and then Step in at "cat_col" it expands to
this: "PRO!$C$2:$C$1400"



"JP" wrote:
You could post the formula!

--JP

On Sep 20, 5:40 pm, Jennifer C. Jennifer
wrote:
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??- Hide quoted text -

- Show quoted text -

Glad to hear it and thanks for letting us know it worked!

--JP

On Sep 21, 7:41*pm, Jennifer C.
wrote:
THANKS JP, I didn't need to do Ctrl F3, I just needed to go into the Name
Manager (I believe that may be a new feature in 2007).

THANKS AGAIN FOR YOUR HELP!!! *

Jennifer

"JP" wrote:
Those are names that are pointing to hard coded ranges. Edit the names
and you can change the definition.

Press Ctrl-F3 and select each name. You'll see the definition in the
Refers To box. Just click inside and press F2 to move around. You can
adjust your range there.

--JP