![]() |
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