| Home |
| Search |
| Today's Posts |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula selecting first 1400 rows of column, need ALL of it.
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 --- |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Text to column and selecting values based on a different column | Excel Worksheet Functions | |||
| Text to column and selecting values based on a different column | Excel Worksheet Functions | |||
| Text to column and selecting values based on a different column | Excel Discussion (Misc queries) | |||
| after selecting 50 rows of a column i can't reference the cells in the rows | New Users to Excel | |||
| Selecting Rows | Excel Worksheet Functions | |||
![Jennifer C.[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
