I have a bunch of cells that call some lengthy VBA code. If I turn off the redraw in VBA, it comes back on when it leaves VBA, which does not do me any good since it repeats for the next cell. My question is, what is the best way to turn off redraw for the whole duration of recalc?
thanks
Fred
thanks
Fred