|
|
#7
10-21-2024, 02:40 AM
|
||||
|
||||
Otherwise, a user-defined function:
Code:
Function addresses(rng As Range) As String For Each cll In rng.Cells addresses = addresses & "," & cll.Address Next cll addresses = Mid(addresses, 2) End Function 2024-10-21_103925.jpg 
|
|
|
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 |
Windows 10 
Office 2021
Threaded Mode