Thread: Macro to add a new row if text length is over 30
View Single Post
  #1   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
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