Technowolf
Board Regular
- Joined
- Aug 28, 2014
- Messages
- 181
I'm using:
To truncate my characters down. Problem is I've got like 11k rows and it takes forever. Is there a faster way to do the entire column?
Code:
Columns("AG:AG").Select
Dim rCell As Range
For Each rCell In ActiveSheet.UsedRange.Columns("AG").Cells
rCell = Left(rCell, 9)
Next rCell
To truncate my characters down. Problem is I've got like 11k rows and it takes forever. Is there a faster way to do the entire column?