Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Writing Range to Array
Hi
try Sub Test() Dim aArray() Dim rng As Range Set rng = Range("A1").CurrentRegion aArray.Value = rng.Value End Sub -- Regards Frank Kabel Frankfurt, Germany Marston wrote: 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Writing Range to Array
Frank Kabel wrote:
Hi try Sub Test() Dim aArray() Dim rng As Range Set rng = Range("A1").CurrentRegion aArray.Value = rng.Value End Sub That doesn't work either, at least not in xl2000. So either it wasn't tested before posting or Frank Kabel is using a later version in which it works. Use aArray = rng.Value or Dim aArray As Variant aArray = rng or aArray = rng.Value Alan Beban |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Writing Range to Array
Hi Alan
just a typo on my site. Forgot to remove the .value part Thanks for the correction -- Regards Frank Kabel Frankfurt, Germany Alan Beban wrote: Frank Kabel wrote: Hi try Sub Test() Dim aArray() Dim rng As Range Set rng = Range("A1").CurrentRegion aArray.Value = rng.Value End Sub That doesn't work either, at least not in xl2000. So either it wasn't tested before posting or Frank Kabel is using a later version in which it works. Use aArray = rng.Value or Dim aArray As Variant aArray = rng or aArray = rng.Value Alan Beban |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Prb: Writing Array functions in VBA | Excel Programming | |||
writing array into excel sheet | Excel Programming | |||
Writing Array Formulas in VBA | Excel Programming | |||
VBA: Writing an array function (like MMult) | Excel Programming |