Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 66
Default build array of columns

Hi,

my problem consist of the following.
I have a listbox filled with spreadsheet column headings ( fields). These
fields are to be selected by the user and then pressing a command to have
these "fields" sent to another sheet.

for example

item number | retail | price | location|

now I got the listbox part. The user will select some or all of the fields
then press a cmdbutton to copy and send it to thisworkbook.

I guess I should be building an array instead of looping every column
matching the listbox rows and sending it one by one.

Any help is appreciated.
CZ


Reply
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
Build an array constant with DATE function CliffD Excel Worksheet Functions 2 April 11th 06 02:51 PM
build up an array using formulas Kezze Excel Discussion (Misc queries) 0 February 15th 05 02:17 PM
build up an array using formulas Kezze Excel Discussion (Misc queries) 0 February 15th 05 02:15 PM
is it possible to build a chart with clustered stacked columns ? Fabio Battagion Charts and Charting in Excel 1 January 27th 05 01:10 PM
how to build a formula to match numbers in 2 columns with the equ. mcdilash Excel Worksheet Functions 1 November 10th 04 05:31 PM


All times are GMT +1. The time now is 07:54 PM.

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

About Us

"It's about Microsoft Excel"