Thread
:
Writing Range to Array
View Single Post
#
1
Posted to microsoft.public.excel.programming
Marston
external usenet poster
Posts: 43
Writing Range to Array
Can someone tell me what I'm not doing correctly?
Sub Test()
Dim aArray as Variant
Dim rng As Range
Range("A1").Select
Set rng = ActiveCell.CurrentRegion.Select
aArray.Value = rng.Value
End Sub
Reply With Quote
Marston
View Public Profile
Find all posts by Marston