Eureka, both work! Your first solution actually works perfectly but in my code i used Values plural instead of Value singlar.

This code is really useful and quite a bit quicker i've noticed.

@snb thanks for both sets of code u are a machine! I think i can possibly incorporate the the ".current region" into my code to fix the variable length problem but i see that it includes headings which are in row 8.