Cell Range to Address Array

		Microsoft Office Forums > Microsoft Excel > Excel
Cell Range to Address Array

FAQ

Thread Tools

Display Modes

10-22-2024, 03:20 AM

p45cal

Windows 10 Cell Range to Address Array

Office 2021

Expert

Join Date: Apr 2014

Posts: 956

Quote:

Originally Posted by ImAhNoBoDy

As I was searching for another solution, I ended up on a site that creates excel formulas using AI. It came up with this and it works:

Code:

=TEXTJOIN(",",TRUE,ADDRESS(ROW(A1:E1),COLUMN(A1:E1)))

Excellent. One of those too few occasions when AI produces a sensible result. Could you provide a link to that site please?

ps, you could use 4 as the ADDRESS function's 3rd argument to lose the $ symbols too.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Using IF AND to filter number in a range, works with dragging, but not in an Array	mda99das	Excel	5	11-17-2022 01:27 PM
Loading an Excel range to an array in VBS	BobBridges	Excel Programming	1	12-25-2020 01:04 PM
Clear all cell colors within a range starting at cell A8 and change row of active cell to yellow	FUGMAN	Excel Programming	7	02-05-2017 08:37 AM
Error: AGGREGATE_doesn't ignore hidden rows for particualr array range	adisco	Excel	1	01-10-2017 10:59 AM
If value of cell A Matches a value in a Range of cells (column) then add value of cell A to cell C	rick10r	Excel	1	07-05-2016 12:07 PM