I have tried you example and it worked using a named cell.

Is there a way to get this to work on a range of cells or do I have to name
each individual cell. This could get very compolicated very fast with the
sheet I am using.

Thanks

Chris