Formatting

[vgurusa]

Hi Ppl,

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

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

Thanks,

Vija

 

[JE McGimpsey]

One way:

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

 

[vgurusa]

Hi JE,

Thats not working, I always get an error subscript out of range error!

Can you suggest another way !

Thanks,

Vija

 

[Nick Hodge]

Vijay

A #9 subscript out of range error is generated if the code can't find a
referenced element in the code, for example if you reference Sheet10 and you
don't have one

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
(e-mail address removed)