U can use usedrange.column.count and usedrange.rows.count
regards
Karthiganesh

"refina" wrote:

Hi Pls say me
1. How to mention a particular sheet name while opening excel with VB script.
2.how to know the rowcount and column count in excel using vb script.


as soon as possible .very urgent