Hi friends

I am using a Web Query to download some stock related data.
The fonts on the web page are of small size and the heading are
in black color as well the data too.

What I did to change the size and color is :

Range("B12").Font.Bold = True
Range("B12").Font.Size = 10
Range("B12").Font.Color = RGB(255, 0, 0)

I have written this code after refreshing the web query. This piece of
code works
for some time....but then font and other things get their original
color and size...
The effect is till the refresh icon is working after that no use of
this piece of code.
I have written this code after the refresh event!!!!!!!!!!

Please put some light on this area.....

Thanks in advance
Anand