Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
I am trying to assign a value to a specific cell in an array (inside a For loop). But for some reason this assignment breaks the loop. Here's the declaration and the For loop: Dim yrow() As Integer Dim i As Integer, k As Integer k = 0 For i = 1 To lrow If IsNumeric(Cells(i, 2).Value) = False Then k = k + 1 MsgBox "*" yrow(k) = i MsgBox "**" End If i = i + 1 Next i The First message box pops up but not the second. And the For loop is not continued further (I guess it is broken)Please help. Srikanth *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Assigning range to array not working | Excel Programming | |||
Assigning 10x1 array to 2nd collumn of 10x3 array | Excel Programming | |||
Assigning 10x1 array to 2nd collumn of 10x3 array | Excel Programming | |||
Assigning array to range inside Excel Object | Excel Programming | |||
Assigning Array Values | Excel Programming |