Selection to Array and Array to Sheet
qpg wrote:
I am looking for and example of how to create a multidimential array (2
dimientions) from a selection and then how to write that array data
(with some modifications) to another location on the same sheet.
any help would be appreciated.
Thank you
Range("C3:E5").Select
arr = Selection
'do whatever
Range("G1:I3").Value = arr
I don't know why you're selecting. You get the same result with
arr=Range("C3:E5")
'do whatever
Range("G1:I3").Value = arr
Alan Beban
|