thanks man,

it was a problem with my workbook, i got an addin or smthn that limited teh color range, i opened another workbook, there i get all teh colors

now i just need to figure out the code to get the grid to work