| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to Read Worksheet Data into VBA Array?
Does anyone know of an efficient way to read worksheet data in a specified range into a VBA array? For instance, imagine I have a congituous matrix of numbers in Sheet1 in cells A1 through G10. How might I insert Range("A1:G10").Values into a VBA array in one fell swoop? Currently I am looping to populate my VBA array (obviously asinine, I know)...surely there must be a better way? Any advice would be gratefully received. -- Peter Bernadyne ------------------------------------------------------------------------ Peter Bernadyne's Profile: http://www.excelforum.com/member.php...fo&userid=7017 View this thread: http://www.excelforum.com/showthread...hreadid=560749 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to Read Worksheet Data into VBA Array?
Sorry, I got it: Dim myarray as variant myarray = Range("A1:G10").value -- Peter Bernadyne ------------------------------------------------------------------------ Peter Bernadyne's Profile: http://www.excelforum.com/member.php...fo&userid=7017 View this thread: http://www.excelforum.com/showthread...hreadid=560749 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Inputting data to one worksheet for it effect another | Excel Discussion (Misc queries) | |||
| Look up Data from Worksheet within same Workbook | New Users to Excel | |||
| How do I reference data from one worksheet to another using combob | New Users to Excel | |||
| Saving data in a worksheet within a workbook | Excel Discussion (Misc queries) | |||
| Automatically pasting worksheet data to new worksheet with formulas | Excel Worksheet Functions | |||
Linear Mode
