Excel VBA Array ?

[pcdaveh]

What is the proper format to read values from excel into an Array. What I'm doing so far isn't working:
I'm just trying to read Column "A" Rows 1 to N


Sub Findduplicates()

Dim DataColumn()
Dim DataColumnElement()
Dim i As Long
Static lastRow As Integer
Dim IRow As Integer

call GetRealLastCell

lastRow = lRealLastRow
ReDim Preserve DataColumn(1 To lastRow)
For i = 1 To lRealLastRow

DataColumn = Range("A" & lastRow).Text

Next i

End Sub

 

[THoey]

This would probably get a better response in an Excel forum. Terry M. Hoey