Hi,

I have this formula :

Range("I3").Formula = "=IF(C3=C2,0,1)"

How can I drag it down to automatically fill all the cells until the last row?

The number of rows I have differs weekly so I need to get a code that drags the formula down automatically to the last cell on the list.

Any help will be appreciated

Thank you.

Chris