Hi there,

Try using:


With Range(ws.Cells(i, 1), ws.Cells(j, 2))

Without fully qualified references, "Cells(i, 1)" and "Cells(j, 2)" will be taken as applying to whichever worksheet happens to be active when the macro reaches that point in its execution.


Hope this helps - please let me know how you get on.

Regards,

Greg M (fellow Dubliner )