Livin404
Well-known Member
- Joined
- Jan 7, 2019
- Messages
- 743
- Office Version
- 365
- 2019
- Platform
- Windows
Hello,
I'm finally getting to the end, and I suddenly realized I am indeed going to have to use custom formatting.
I have been using the macro below which clears everything including the formatting. If I use the "Clear Contents" (image) it leaves all the formatting. Including the colors and boarders. Is there something I can write which Clears everything but leaves the coding that changes colors for cells. Basically it I'm left with a blank sheet, but when I run the main Macro it will pick up the that I have for
I'm finally getting to the end, and I suddenly realized I am indeed going to have to use custom formatting.
I have been using the macro below which clears everything including the formatting. If I use the "Clear Contents" (image) it leaves all the formatting. Including the colors and boarders. Is there something I can write which Clears everything but leaves the coding that changes colors for cells. Basically it I'm left with a blank sheet, but when I run the main Macro it will pick up the that I have for
VBA Code:
Sub Clear_68()
Dim ws As Worksheet
For Each ws In Sheets(Array("Outbound"))
ws.Cells.Clear
ws.Cells.RowHeight = 14.4
ws.Cells.ColumnWidth = 8.11
Next ws
End Sub