Hidden columns not formatted.

[woon8888]

Hi Experts,

will like to ask a question? initially when i program my VBA to insert a colored row in a hidden column sheet.

for e.g. columns B:E is hidden.

when i insert a blue colored row, the columns B:E even though hidden it's supposed to be blue colored.
but at times it's not. Why is that so? sometimes it's full sometimes it's not.


hidden

unhidden

 

[6StringJazzer]

Question cannot be answered without seeing the code you are using.

 

[woon8888]

Hi, apologies. My vba

sheet1.Rows("3:4").Insert Shift:=xlDown, CopyOrigin:=xlFormatFromLeftOrAbove
sheet1.Range("A3:J4").Interior.color = 11848959
sheet1.Range("A1:J12").Copy sheet2.Range("A1")

the sheet2 A1:J12 is not showing full colored cells, it's showing truncated color cells.