How to read all cells used in a column

[antmar904]

I'm trying to read all cells used in column "C" in excel to an array but not sure how.

 

Local $NameArray = _Excel_RangeRead($oWorkbook, $oWorkbook.Activesheet, $oWorkbook.Range["C"].End)

 

[JLogan3o13]

The help file literally has this example (example #3). Just change the Formulas parameter to Value.

[antmar904]

Wow!

$oWorkbook.ActiveSheet.Usedrange.Columns("C:C"))

[water]

If the help file does not help than it is a good idea to have a look at the wiki