Hi How do i use the worksheet change sub but not have it
fire until after the report is created.

as at the moment each time a cell is written to when
report is being created it just messes up