simple vb script to open,
 

name empno sno

hhh vinayaga hkjg
queen vinayaga hkjg
king vinayaga hkjg
hgfh jhg hkjg
hgfh god hkjg

Total rama hkjg


In the above ,excel format i want a simple vb script.
1.open this excel sheet from its location.
2.find the row count for column 2.
3.this is placed in sheet1.
4.from the name queen i should colour all the rows till bottom.
5.from the name queen to total i should find sno for total.

Please reply soon