Did you declare z as a range?

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Tim" wrote in message
...
When i try and run that code Tom it says that z is not defined properly,
failed to provide a valid object qualifier.