I have various named ranges that, for example, go from N6:S22. However within this range, in the column Q, in each row in the range, the cell in column Q needs to be range-named the text that is in column R for that cell. For example, cell Q15 needs to be range-named what the text is in cell R22. So, i have a range names "ss_WAL" that is N6:S22, I need to loop through the Q6:Q22 cells and range-name them the values in R6:R22. All this must be done in VBA. I have the below but am not sure how to proceed.
.Cells(intCount, 4).AddComment Me.txtRangeName.Value 'Adds comment with range name
.Cells(intCount, 4).Name = .Cells(intCount, 5).text 'Defines the name of the range for the column number