vba formating

[jorge.duarte]

My problem is:
I make some formatings in run time mode like :
Worksheets(2).Range(Cells(intColuna, 1), Cells(intColuna,
2)).Interior.Color = RGB(200, 200, 200)
Worksheets(2).Range(Cells(intColuna, 1), Cells
(intColuna, 2)).Font.Bold = True

and so on ....


the problem is,the clearcontents command doesnt release or
clear the settings made previous in the sheet, and cause
of this, when i recall my sheet with another range, some
cells appear bold or with some other color, when they
should apear this time clear of every format what so ever.


Sorry for any english mistakes, and i hope u understand my
problem


Thks in advance
Jorge

 

[Frank Kabel]

Hi
you may use
Range("A1").ClearFormats