PDA

View Full Version : [SOLVED] Clear Contents VBA



Nick72310
04-06-2016, 09:14 AM
In the image below, the cells formatted in black contain data that I do not want erased. Every cell that is colorless, I need cleared. How can I do that? I feel it's a simple line of code but I don't know it. Thank you!

15855

Paul_Hossler
04-06-2016, 01:13 PM
With ActiveSheet
Range(.Cells(2, 4), .Cells(.Rows.Count, .Columns.Count)).Clear
End With

Nick72310
04-08-2016, 09:24 AM
That works great! And easy to modify. Thanks Paul_Hossler!