Macro to add font color and cell color + to add a simple formula in a specific range

[hnt007]

Hi! Thank you very much for helping me out with this... I'm trying to have a macro (that I would link to a button called RESET) that will apply a bunch of things to the range D8:D1000:

- adding the formula =L8 in D8, =L9 in D9, =L10 in D10 etc until =L1000 in D1000
- font color > black
- cell color > none

 

[hnt007]

This is working GREAT!! Thank you so much for the time you spent on this, really appreciate it!

 

[johnnyL]

Glad to help.