| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
loop Statement
I have calculated a data using a formula and I need the code to loop thru the
sheet running the formula thru a column. Autofill does not work because it will give me Jan-1 Jan-2 etc, In column A I have a value DJAN-1 DJan-2 Djan-4 etc this formula will work correctly to give me the data Sheets!graphdata.Range("r4") = (dwmonth & "-" & Mid(Sheets!graphdata.Range("A4"), 6, 2)) in R5 I want it to look in cell A5 to get the value and then insert it There are 343 rows it has to loop thru putting the value in A? in R? what is the quickest and easiest way of doing this Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| for loop with if statement | Excel Worksheet Functions | |||
| If statement - Loop? | Excel Discussion (Misc queries) | |||
| Help with a loop VBA with an if statement | Excel Programming | |||
| continue statement in a loop | Excel Programming | |||
| Do Until loop with if statement | Excel Programming | |||
Hybrid Mode
