Hi Darren

Try this:

Select a few sheets holding ctrl + click in the sheets labels, after this,
you can insert data in tha both sheets. just only entry data in the
activesheet.

Regards,

Fernando Ortiz

"Darren" escribió en el mensaje
om...
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