Thanks Jon. There doesn't seem to be any blanks of errors in the data
but converting from XY to columns and then back again after the ranges
have been changed seems to work a treat. All I can't figure out is
why!?

Alan