LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 21
Default Concatenate / Select Subset of Arrays

My specific question relates to 2D arrays:

1. How to add say a new 10 column row to an existing array with x rows
already in it

2. How to create a new array from row 2 col 2 to row 6 col 8 from am
existing 10 x 12 array (pretty easy with a Range object).

Obviously I can do it by looping through the arrays and assigning values one
at a time but is there a better alternative.

Andrew
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Select Subset of Rows/Cols Joe Thompson Excel Discussion (Misc queries) 1 May 19th 10 05:41 AM
concatenate with arrays Ashish Mathur[_2_] Excel Worksheet Functions 3 August 4th 09 12:38 AM
concatenate with arrays Lars-Åke Aspelin[_2_] Excel Worksheet Functions 0 August 1st 09 10:08 AM
concatenate with arrays Bernd P Excel Worksheet Functions 0 August 1st 09 09:11 AM
How to enter symbols for subset or element of a subset in Excel? rwcita Excel Worksheet Functions 1 January 23rd 06 09:27 PM


All times are GMT +1. The time now is 08:31 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"