Excel Macro Question - Autofill formula
Posted on 2010-09-17
I am working on a macro in excel and I am having some issues with an autofill function. I am trying to autofill a formula for all rows that have a value in column C. My issue with my current macro is this....
when i recorded the macro, the macro recorded that i wanted to autofill the formula for cells D2:D539.
VBA code example:
ActiveCell.FormulaR1C1 = "=IF(ISBLANK(RC[-2]),R[-1]C,(RC[-2]))"
The number of rows will change each time I run this macro, could be more, could be less. That is why I would like to apply this formula to only cells where the Same row column C has a value. Is there a code i can type into this VBA string to help?