I want to copy the following function across only the cells displayed in my
autofilter

='[RDD Register.xls]Oban'!G59

But it's picking up the cells hidden and the numbers jump out of sequence on
the filtered sheet.

Is there any way to overcome this?

D Dawson