Thread: Macro to add a new row if text length is over 30
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Melanie Melanie is offline
external usenet poster
  
Posts: 78
Default Macro to add a new row if text length is over 30
To clarify, I mean if the length of the characters in the column S cell is
over 30, I need to move characters 31+ to the new line.

"Melanie" wrote:

I need a macro to add a new row (and copy existing data in columns A-R) if
the length of the items in column S is over 30. If the text is over 30, I
need to move the characters over 30 in the new row in column S. I have the
data length of column S in column Z.

Can someone help me with this? Thx!
Reply With QuoteReply With Quote