$$Excel-Macros$$ Re: Help with replacing formula with value over large range

nUpdating = True Application.Calculation = xlCalculationAutomatic End Sub == Thanks to everyone who helped Cheers Ravi On Saturday, December 16, 2017 at 11:44:17 AM UTC+5:30, Ravi K wrote: > > Hi > > Can someone please explain why this macro does not work > I have

$$Excel-Macros$$ Help with replacing formula with value over large range

Hi Can someone please explain why this macro does not work I have no formal training in VB or any programming so everything in the macro is bits taken from various posts What I need to do is put 1 or 0 over a range that starts at B8 and ends at the last column with data at row 44652 but if I