Has anyone got any Idea how I can insert data into a range that spans
two worksheets with one command. At the moment I need to select each
worksheet and insert the data rather than have the data inserted
without selecting the worksheet.

I hope this makes sense.
Darren