Cheers Tom,
I too canne find nowt, grrr
basically i have been using the dynamic name ranges so loved by Oz who currently frequents this bord, the only problem is that the offset method is a little seams to get a little upset because my dynamic range is part of a query, when you refresh the queery the range only selects the refreshed bit, not the refreshed bit and adjacten cells, so I am looking for a really simple version, ie the current region method, to select the block that i would like to be my named range.
any suggestions?