Thread: array data type
View Single Post
  #1  
Old June 15th, 2004, 03:38 PM
anjem
external usenet poster
 
Posts: n/a
Default array data type

Hi, I'm trying to take a column of integers and input them into an array
which I can then use for a loop instead of using this format:
If (Worksheets("NeeleyNedPRE").Cells(pRow, pCol).Value = 0) Then

For some reason this doesn't work because the column selected all
resets to zero rather than running the loop correctly and I think that
an arrray might be the only option. What the easiest way to solve this
problem?
-Andrew


---
Message posted from http://www.ExcelForum.com/