View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
petedacook petedacook is offline
external usenet poster
 
Posts: 27
Default Write select columns to array & back to another spreadsheet

Hello,

I am trying to take data from select columns in a spreadsheet adn write it
to another spreadsheet. The ciolumns are not aligned in any order, and the
number of rows is unknown from week to week.

For example, I need to take columns: A, B, E, F , j, k, L, copy to array,
and the number of rows is unknown. I then to to spit each column back into
another spreadsheet in a specified column.

I have been reading two books, but it seems they only give examples of
arrays with a known number of rows.

Any help is greatly appreciated. I have been playing with this for days.


Pete