Hi Everyone,
We have an active working spreadsheet that is pulling percents based on a date range. I'm looking for help with a macro that could turn the range I12:AH358 into a constant value only IF its returning a value. My formula is referencing dates (some of which are in the future), so its showing a blank. When its showing blank, I want the formula to stay. If its returning a value, I want it to get rid of the formula and just show the value.
In the attached screen shot, you will see values are showing up to column R. Is it possible to do a macro to turn all these to this value (removing the formula), but leave the formula in all columns S and beyond?
Bookmarks