| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Fill Down to variable row
I tried some of the suggestions in other posts, but none seemed to work for
me. How can I fill down formulas I've entered (via macro) in R3C23 and R3C24 to the last row of my sheet that has data. The columns will stay constant, but the rows will vary. So far I have this: Application.Goto Reference:="R3C23" ActiveCell.FormulaR1C1 = "=IF(RC[-13]<RC[-15],""expedite"")" Application.Goto Reference:="R3C24" ActiveCell.FormulaR1C1 = "=IF((RC[-14]/RC[-16])*100<50,""fast"")" Filling down those two formulas is where I'm lost. Thanks for any help, Sean |
| 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 | |||
Threaded Mode
