Related:
- Next empty cell vba
- Select next empty cell vba - Best answers
- Select next empty row vba - Best answers
- Select a subset of cells within a row ✓ - Forum - Excel
- Excel VBA to Select Empty Cell in a Row - How-To - Excel
- Selection.autofill destination to last row vba ✓ - Forum - Excel
- Excel - Delete certain cells of active row - How-To - Excel
- Copying cond. format for entire row based on 1 cell to other row ✓ - Forum - Excel
1 reply
rizvisa1
- Posts
- 4476
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- August 2, 2020
TRY THIS
.
.
.
ActiveCell.Value = Player.Value
Activecell.offset(0,4).value=Score.value
'find last used cell on the row to the right
ActiveCell.End(xlToRight).Select
'move one cell to the right from the last used cell
ActiveCell.Offset(0, 1).Select
.
.
.
.
.
ActiveCell.Value = Player.Value
Activecell.offset(0,4).value=Score.value
'find last used cell on the row to the right
ActiveCell.End(xlToRight).Select
'move one cell to the right from the last used cell
ActiveCell.Offset(0, 1).Select
.
.
