Furthing to my last post....
It errors out. I press 'End'. But investigating the 2nd sheet it has
actually done the .UsedRange.Value line as the links are not there and
you can confirm this as the edit menu links is greyed out.
Donna