Using VB to change cells' properties in Excel

Hi all,

I want to write a VB program that can:

1. read from an excel file
2. determine some cells and then change the background color of these cells.

The first step, I think I can do easily by following all steps in this forum. I just wonder if I can do the second step.

Please help me,

Thank you in advance.

Hi,

if u find that u have change the 1st row 1st column's background color

u can use the below statement



u can replace the row column values in the cells object

Hope this will helps u

Regards,
Satish Kumar J....