Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
i'm trying to use a For Each loop but I can't get it to work. I don't think
that the counter is necessary but i'm not sure how this should be written. Any help streamlining this would be appreciated. Static counter As Integer For Each Row In Range("TotalData") ImplementPlace = Worksheets("Implementation Summary").Range("ImplementPlace").Cells(2, 1) counter = counter + 1 If Worksheets("Post-Assessment").Range("TotalData").Cells(counter, 15) = "True" Then If Worksheets("Post-Assessment").Range("TotalData").Cells(counter, 10) = "True" Then Worksheets("Implementation Summary").Range("ImplementMeth").Cells(ImplementPl ace, 2) = "S" Else Worksheets("Implementation Summary").Range("ImplementMeth").Cells(ImplementPl ace, 2) = "IR" End If Worksheets("Implementation Summary").Range("ImplementMeth").Cells(ImplementPl ace, 3) = Worksheets("Post-Assessment").Range("TotalData").Cells(counter, 2) Worksheets("Implementation Summary").Range("ImplementMeth").Cells(ImplementPl ace, 4) = Worksheets("Post-Assessment").Range("TotalData").Cells(counter, 7) End If Next Row |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to Delete blanks between a range and populate only the names inthe given range | Excel Discussion (Misc queries) | |||
Populate cell range | Excel Worksheet Functions | |||
Populate a table with a dynamic range | Excel Worksheet Functions | |||
Increasing a range in a loop | Excel Programming | |||
Need Code to Populate Cell Range | Excel Programming |