Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Array Manipulation with VBA coding
I have large array which I would like to manipulate by VBA macros.
The array size is A1:Z100 ( 26 columns X 100 rows) The data in A:column (text) and in B:column (numeric) are related to each other. That is paired to each other. Likewise in C: (text) and in D: (numeric) and so on until Y: Z: There are however blanks in both corresponding columns at the end of some rows. I need to move each pair of columns sequentially starting with C: D: ...........down to Y:Z: underneath A: and B: Being brand new to VBA, until this week (thanks goes to JMB for introducing me to VBA...I have discovered the VBA language manual) I am still struggling with the synatx. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
array manipulation | Excel Worksheet Functions | |||
Text manipulation | Excel Worksheet Functions | |||
Array Manipulation | Excel Worksheet Functions | |||
Array Manipulation | Excel Worksheet Functions | |||
Array Manipulation | Excel Worksheet Functions |