This might be elementary, but I cannot get it to work.
I need to name range in VBA, work with the named ranges afterwards and change the names. I have split it into e couple of questions below.
1. Naming a range
By using 'Worksheets("Ark1").Range("C4").Name =...