Select cells in an array

		Microsoft Office Forums > Microsoft Excel > Excel
Select cells in an array

FAQ

Thread Tools

Display Modes

02-05-2024, 10:25 AM

xexeu

Windows 10 Select cells in an array

Office 2016

Novice

Join Date: Oct 2018

Posts: 7

I need to make a selection that starts in cell A169 and ends in cell A29. The matrix has 173 rows - it starts at A1 and ends at A173.

I tried =INDEX($A$1:$A$173, ROW(INDEX($A$1:$A$173, 169)):ROW(INDEX($A$1:$A$173, 29))) but it gave an error.

Last edited by xexeu; 02-05-2024 at 12:54 PM.

Tags

select cells

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Select a range of cells to cpy based on a text searh	oscarlimerick	Excel	2	07-18-2023 01:27 PM
Select all cells in a column , even when blank...	Chayes	Excel Programming	4	05-30-2018 10:35 AM
Conditional formating all cells in an array based on adjacent cells	deejay	Excel	6	12-20-2016 12:00 PM
Help with Index Function to Select Range of Cells	bretyuin	Excel	1	02-24-2016 05:11 AM
Convert String Array to Integer Array from a User Input?	tinfanide	Excel Programming	4	12-26-2012 08:56 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:11 PM.