Related:
- Naming Cells
- Excel arrow keys not moving cells - Guide
- Excel macro to create new sheet based on value in cells - Guide
- Arrow keys scrolling in Excel ✓ - Excel Forum
- Based on the values in cells b77 ✓ - Excel Forum
- Excel if range of cells contains specific text then return value ✓ - 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"