Hi I have an interesting one for you.

If I have cells A1:A1000, G1:G1000 & K1:K1000

is it possible to create a named range for each of the 3000 cells in code and call them all sequentially 1-3000

Thanks if you can help. This will save me so much time!

Rob