Programming Question
In VB, I want to load an array and then assign that array to a row in a
designated sheet. Question 1: How do you assign an array into a Row in a Sheet? Sheets("Name").??? = ROW_ARRAY Question 2: What form does RowData have to be? Is a one dimension matrix or a two dimension matrix or something else? ROW_ARRAY can have two forms: either ROW_ARRAY(a number) or ROW_ARRAY(). Is there different coding for these two definitions? Thanks for your help, Capt Mac |
Programming Question - Better Solution
If you have an array
Dim ARRAY(2,5) you can easily place it in an Worksheet as follows: RANGE_STR = "A1:E2" ' Note same arrangement as ARRAY WorkSheet.Range(RANGE_STR).Value = ARRAY Capt Mac |
Programming Question - Better Solution
Dim ARRAY(2,5)
You can't use "Array" as a variable name; it is a reserved word in VBA. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Mac Lingo" wrote in message link.net... If you have an array Dim ARRAY(2,5) you can easily place it in an Worksheet as follows: RANGE_STR = "A1:E2" ' Note same arrangement as ARRAY WorkSheet.Range(RANGE_STR).Value = ARRAY Capt Mac |
All times are GMT +1. The time now is 09:16 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com