One way:

Application.Workbooks("Book1.xls").Sheets("Sheet1" ).Range( _
"1:10").NumberFormat = "0.00"


In article ,
vgurusa wrote:

Hi Ppl,

How to format the Worksheet programatically from a software like Visual
Basic ?

For e.g. the worksheets specific rows have to be changed into
numberformat="Number" instead of default "General"

Thanks,

Vijay