| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
[column(101:200)] confusing
Hi all,
[Row(101:200)] will produce two dimension array, 100 rows and 1 column, containg values from101 to 200. How about [column(101:200)]? Clara -- thank you so much for your help |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
[column(101:200)] confusing
Are you trying to pick up a 65536 row x 100 column array:
Dim a As Variant a = Columns(101).Resize(, 100).Value (in xl2007, this is 1MB rows) clara wrote: Hi all, [Row(101:200)] will produce two dimension array, 100 rows and 1 column, containg values from101 to 200. How about [column(101:200)]? Clara -- thank you so much for your help -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
[column(101:200)] confusing
Same thing except:
column(101:200) produces 1 row, 100 columns One goes vertical, the other horizontal. "clara" wrote: Hi all, [Row(101:200)] will produce two dimension array, 100 rows and 1 column, containg values from101 to 200. How about [column(101:200)]? Clara -- thank you so much for your help |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Confusing spreadsheet | Excel Discussion (Misc queries) | |||
| Confusing results | Excel Worksheet Functions | |||
| Menu confusing | New Users to Excel | |||
| Confusing Function | Excel Worksheet Functions | |||
| Confusing Problem | Excel Discussion (Misc queries) | |||
Linear Mode
