There are a multitude of questions asked on this topic; however, I have not been able to find an exact answer for my particular situation. Lots of questions already posed are for older versions of vb .net that I do not think work in my environment.
I am using vb .net 2010.
I want to be able to assign a specific background color to as specific cell within an excel spreadsheet from vb. From questions posed and answered before, I have come up with the following:
oSheet is defined as the active excel sheet.
oSheet.Cells(intRow, intCol).Interior.Color = ConsoleColor.Red
oSheet.Cells(intRow, intCol).Interior.Color = 8
BOTH of the above actually color the specified cell; however, the color is BLACK. Yes, I have tried NUMEROUS values. I have even cycled through a range of 8 through 100, and placed in 93 different cells, but the background color is always black.
I am sure I am doing something stupid.
Any and all help is greatly appreciated.
thanks in advance.