Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I'm having a problem with the values K and T
For K = 305 To 316 For t = 319 To 330 For Each cell In Range("G11:N298") c = Array(7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20) For i = 0 To 13 If Cells(t, c(i)).Value - 1 = Cells(K, c(i)) And Cells(cell.Row, c(i) + 97) = "x" Then cell.Value = Cells(9, c(i) + 97) End If Next i Next After the array and the rest of the code has finished I want t increase the value of K by one and the value of T by one. No matte where I put it I get an error. What am I missing? Thank -- Message posted from http://www.ExcelForum.com |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
outer join in query | Excel Discussion (Misc queries) | |||
How do you repeat outer row field in a pivot table down the row | Excel Discussion (Misc queries) | |||
Outer Joins | Excel Discussion (Misc queries) | |||
MS Query Outer join with three tables | Excel Discussion (Misc queries) | |||
Columns in Full Outer Joins | Excel Programming |