"Tom Ogilvy" wrote in message
...

If you were on another sheet or the code was in a sheet module, then the
unqualified

Range("A1").Value

would not refer to the RI sheet and could be problematic - however, I
would
not expect selection.currentregion.name to have a similar problem.


I think that is the problem as Jacqui is trying to select the current in ws
(RI), which if not active will throw an error.