Returning the to the active cell after VBA code is run RRS feed

  • Question

  • I have some VBA which cycles through all the tasks in a plan, and changes the font colour based on the various factors.  My issue is that the active cell changes to the last task.  How do set the active cell back to the task before the VBA code was run? 

    Do I either set some reference to the active cell and reset it afterwards (and how would I do this) or is there a way to turn off the updating (like screenupdating - false works a treat, but only partially solves my issue).


    Ben Howard [MVP] blog | web
    Tuesday, July 5, 2011 7:52 PM


All replies