Hi, kinda a noobie at VBA here. I am trying to get, on a button press, to have the cells between two points be filled with just a 1 when i press a button on the worksheet. The two points are different each time and the cells have formulas in them which is what defines the start and end points so the function will have to overwrite these. I am basically trying to achieve this at the press of a button and just for the fill to right one.

Any help is greatly appreciated