Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello, I need assistance with creating code for a loop (which i'm not good at
at all). I have this code below that I'm only showing a portion of. I want to turn this into a For Loop code because I have to do the below code from "SP1", "Total1" through "SP30" and "Total30" so I'm looking at over 60 lines of code. How can I trun this into a For i = 1 to 30 type code? Any help is appreciated. Code: SP1.Value = Sheets("data").Range("Line1SP").Value Total1.Value = Sheets("data").Range("Line1tot").Value SP2.Value = Sheets("data").Range("Line2SP").Value Total2.Value = Sheets("data").Range("Line2tot").Value SP3.Value = Sheets("data").Range("Line3SP").Value Total3.Value = Sheets("data").Range("Line3tot").Value SP4.Value = Sheets("data").Range("Line4SP").Value Total4.Value = Sheets("data").Range("Line4tot").Value |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
statistics - guidance | Excel Worksheet Functions | |||
Need some guidance | Excel Worksheet Functions | |||
looking for logic guidance | Excel Programming | |||
After much help from this forum, I still some guidance... | Excel Discussion (Misc queries) | |||
Architectural guidance, please | Excel Programming |