Related:
- Naming Cells
- Ikea naming system - Home - Apps & Sites
- Excel arrow keys not moving cells - Guide
- How to delete cells in word - Guide
- "Cells(1, "a")" "type mismatch" ✓ - Excel Forum
- Based on the values in cells b77 b88 ✓ - Excel Forum
2 responses
Maybe you can try using the Name Property instead of using the R1C1 style reference.
Range("B3").Name = "corr1"
Range("C3").Name = "corr2"
Range("D3").Name = "corr3"
Range("E3").Name = "corr4"
Range("F3").Name = "corr5"
Range("B3").Name = "corr1"
Range("C3").Name = "corr2"
Range("D3").Name = "corr3"
Range("E3").Name = "corr4"
Range("F3").Name = "corr5"