Using IF Statement With .FormulaR1C1

I am trying to create a formula in VBA that place "1-7 Days", "8-15 Days", or ">15 Days" in column E, based on the number in the corresponding row of column D. The data starts with row 3.

I need the formula to fill down to the bottom of the data set. Below is what I have so far, but I'm not sure what I am doing wrong. I keep getting a Run-time error '438' "Object doesnt support this property or method"

Please assist in identifying my problem, and also how I could get this to carry down to the bottom of the data set without using a loop.

Thank you.

Please Login or Register  to view this content.

Norie,

For some reason when I copied your code, it worked.... not sure why it made a difference, but thank you again for your help.