Hello everyone
I'm new in vba and I have a question regarding interior.color property.
Here is an example of code i wrote:
Do while i <= 100
Cells(i,8).Interior.Color = RGB(255,0,0)
i = i+1
Loop
But however, this did'nt fill the background of the cell. But if I replace Interior with Font e.g. it makes the color of cell red.
Does anyone know what is wrong the interior-syntax?
thanks in advance
|