June 15th, 2004, 05:17 PM
|
|
array data type
anjem wrote:
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/
Post the troubling code.
Alan Beban
|