Hi Garry

<snip
but it's academic now as Scossa has provided a neat solution that does
away with the Set statements altogether.

Exactly what others have been saying as well. Good for Scossa to give it
to you the way he did!<g

I have to admit I'd been using Set statements because it avoids a lot of
typing <bg

That said, Scossa's solution of
[General_KV].Copy .Range("A6")
is a lot shorter than
Worksheets("Lookup").Range("General_kV").Copy .Range("A6")
and as I already have
General_KV.Copy .Range("A6")
in place, extending this to
[Lookup!General_kV].Copy .Range("A6")
isn't a great deal of work, especially with copy/paste.

--
Ian
--