JackDanIce
Well-known Member
- Joined
- Feb 3, 2010
- Messages
- 9,922
- Office Version
- 365
- Platform
- Windows
Hi,
Have a 2D array R x C in size, C max (column count) = 14.
Is there syntax (without explicit ref e.g. arr(x,1) & arr(x,2) & ... & arr(x,8) ) to join first 8 columns per row?
Psuedo code:
where 8 represents 8th column (not 8th char!)
Ideally, without creating a function to mimic this either.
TIA,
Jack
Have a 2D array R x C in size, C max (column count) = 14.
Is there syntax (without explicit ref e.g. arr(x,1) & arr(x,2) & ... & arr(x,8) ) to join first 8 columns per row?
Psuedo code:
Code:
myKey = LEFT(join(arr), 8)Ideally, without creating a function to mimic this either.
TIA,
Jack
