Toggle navigation
Home
Latest pastes
FAQ
Random
Register
Login
VBA Remove Text Wrap
SUBMITTED BY:
gamefreak
DATE:
June 25, 2019, 5:41 p.m.
FORMAT:
Text only
SIZE:
331 Bytes
Raw
Download
Tweet
HITS:
678
Go to comments
Report
#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.
Sub RemoveWrapText()
Cells.Select
Selection.WrapText = False
Cells.EntireRow.AutoFit
Cells.EntireColumn.AutoFit
End Sub
Please enable JavaScript to view the
comments powered by Disqus.
comments powered by
Disqus