hi,
whilst looking for something also relating to non contiguos named ranges, i came across this post and thought i would add my 2 pennies worth
why use a defined range when you can build the range as a string
'Sub HR_Range()
Application.ScreenUpdating = False
Dim UR As Long...