Finding Row & Column of selection relative to named range

[BobFast]

I have a chart of names, 12 rows by 4 columns. I have named this range PLAYERS. I would like to select a name and have the vba code populate variables with the row number and column number relative to the named range. The range PLAYERS does not start at A1, but rather is in the middle of the worksheet.

 

[Tetra201]

Range("PLAYERS").Cells(1, 1)

returns the upper left cell of the range. You can use Offset to populate the target cell, e.g.,

Range("PLAYERS").Cells(1, 1).Offset(0, 4) = "Test"

 

[BobFast]

Thanks, that's helpful but I really want to know the column number and the row number of the selected cell in PLAYERS, so I can use those numbers to refer to the team that the player is on and determine if that player is a 1, 2, 3 or 4 player. Once I know that I can run several other routines to move records around.

 

[Tetra201]

Is this what you need?

RelRow = ActiveCell.Row - Range("PLAYERS").Row + 1
RelCol = ActiveCell.Column - Range("PLAYERS").Column + 1

 

[BobFast]

YES, that works perfectly. Many thanks.