VBA Remove Text Wrap

SUBMITTED BY: gamefreak

DATE: June 25, 2019, 5:41 p.m.

FORMAT: Text only

SIZE: 331 Bytes

HITS: 515

  1. #This code will help you to remove text wrap from the entire worksheet with a single click. It will first select all the columns and then remove text wrap and auto fit all the rows and columns.
  2. Sub RemoveWrapText()
  3. Cells.Select
  4. Selection.WrapText = False
  5. Cells.EntireRow.AutoFit
  6. Cells.EntireColumn.AutoFit
  7. End Sub

comments powered by Disqus