Alvaroro84
Board Regular
- Joined
- May 13, 2022
- Messages
- 65
- Office Version
- 2016
- Platform
- Windows
Instead of applying it into on cell what can i change to apply it to the whole column?
VBA Code:
Sub Return_nth_character()
'declare variables
Dim ws As Worksheet
Set ws = Worksheets("sheet4")
'extract the 3rd character from a string
ws.Range("b1").EntireRow.Select = Mid(ws.Range("A1"), 3, 16)
End Sub
Last edited by a moderator: