Limit characters
For Each cell In Me.Range("A2:A301")
cell.Value = Left(cell.Value, 15)
Next cell
--
---
HTH
Bob
(change the xxxx to gmail if mailing direct)
"Patrick Simonds" wrote in message
...
I use the code below to populate column A. Is there any way to change the
code to limit it to the first 15 characters from the left?
Me.Range("A2:A301").Value = Me.Range("B2:B301").Value
|