How to Read Worksheet Data into VBA Array?

  • Thread starter Thread starter Peter Bernadyne
  • Start date Start date
P

Peter Bernadyne

Does anyone know of an efficient way to read worksheet data in
specified range into a VBA array?

For instance, imagine I have a congituous matrix of numbers in Sheet
in cells A1 through G10.

How might I insert Range("A1:G10").Values into a VBA array in one fel
swoop?

Currently I am looping to populate my VBA array (obviously asinine,
know)...surely there must be a better way?

Any advice would be gratefully received
 
Back
Top