Related:
- Naming Cells
- Based on the values in cells b77 b88 ✓ - Excel Forum
- Lg tv naming - Guide
- How to delete cells in word - Guide
- Excel arrow keys not moving cells - Guide
- Arrow keys scrolling in Excel ✓ - 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"