VBA Code to Redact Specified Range in Excel

VBA Code to Redact Specified Range in Excel

August 12, 2016

Here's a little VBA code of my own devising to redact a range of cells in an Excel spreadsheet.

 

We begin with a spreadsheet that looks like this:

 

  Press ALT + F11 and then insert a module with this visual basic code:

 

Sub textcolor()
Range("A1:A3").MergeCells = True
Range("A1:A3").Font.Color = vbWhite
Range("A1:A3").Interior.ColorIndex = 1
Range("A1").Value = "Redacted"
End Sub
 

 

Run the macro and we get a redacted range:

 

 

 

 

Please reload

Contact Me With Your Litigation Support Questions:

seankevinoshea@hotmail.com

  • Twitter Long Shadow

© 2015 by Sean O'Shea . Proudly created with Wix.com