Autofromatting!
 

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


--
vgurusa
------------------------------------------------------------------------
vgurusa's Profile: http://www.excelforum.com/member.php...o&userid=28100
View this thread: http://www.excelforum.com/showthread...hreadid=478613

Autofromatting!
 

Vijay

It can be done but some more detail would be handy.

All worksheets of new books?

All worksheets of existing books?

Some sheets or one sheet?

Are the rows contiguous or interspersed throughout?

Could be as simple as creating a template upon which all new books are based
or a sheet template for new sheets.

Existing sheets and books would require VBA code, either workbook_open or
sheet_activate or similar.


Gord Dibben Excel MVP

On Sun, 23 Oct 2005 16:46:06 -0500, 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