I’m trying to change the background color of a cell at a specific bookmark using:
builder.movetobookmark(strBM)
builder.Cellformat.Shading.BackgroundPatternColor = System.Drawing.ColorTranslator.FromHtml("#c0c0c0")
It moves to the bookmark properly, but I get this error on the next line:
Microsoft VBScript runtime error '800a01a8' Object required: ''
It’s like it doesn’t understand “System.Drawing” or have access to it. Any ideas?