| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Fill Down to variable row
You can use "Do While" Loop, but you can only enter one formula
intLOOP is a local variable, serves as a row counter until row "c+intLOOP" = blank ' Loop to copy formula to every Row in column "D" intLOOP = 1 Do While Range("c" & intLOOP).Value < "" Range("d" & intLOOP).Formula = "=IF(RC[-13]<RC[-15],""expedit*e"")" intLOOP = intLOOP + 1 Loop Let me know if you need any additional assistance. Roberto |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How fill series containing one variable and one fixed value in XL | Excel Discussion (Misc queries) | |||
| "Type mismatch" when I try to fill an Array variable with "+" | Excel Discussion (Misc queries) | |||
| why is it saying sheetcnt is "variable not defined" how to do a global variable to share over multiple functions in vba for excel? | Excel Worksheet Functions | |||
| Fill a listbox with data from variable range | Excel Programming | |||
| Passing Row variable to row Auto fill logic | Excel Programming | |||
![Beto[_4_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
