If you're creating the report in code, wrap your report generation
code with

Application.EnableEvents = False
'Do report stuff here
Application.EnableEvents = True

You'll then need to have one last change to fire the
Worksheet_Change() macro.


In article ,
"Andrew haycock" wrote:

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