Thread: Named range in an array
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
JE McGimpsey JE McGimpsey is offline
external usenet poster
  
Posts: 4,624
Default Named range in an array
One way:

Dim arr As Variant
arr = Range("A1:A5").Value


In article ,
"Frigster" wrote:

Hi,

I have five cells on a row (A1:A5). This range is named "xyz".
How can I transform this range in an array with VB code?
Reply With QuoteReply With Quote