Thread: Limit characters
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JLGWhiz JLGWhiz is offline
external usenet poster
  
Posts: 3,986
Default Limit characters
Try this:

Me.Range("A2:A301")= Left(Me.Range("B2:B301").Value,15)


"Patrick Simonds" wrote:

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



Reply With QuoteReply With Quote