ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   build array of columns (https://www.excelbanter.com/excel-programming/313204-build-array-columns.html)

Cesar Zapata[_2_]

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




All times are GMT +1. The time now is 09:41 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com