Change Cell Format

[SRV....Frenzy]

Hi all,

Can you suggets how can i change the format of my cell to accept
percentage with two decimal places?

Since, i am adding a new worksheet in my code, i also need to make
sure that the cells have percentage format... have a look

ActiveWorkbook.ActiveSheet.Range("G5").Formula = "=F5/F15"

I want to change the format of G5 cell

Please, provide the code..

thanks in anticipation..

 

[Barb Reinhardt]

If I don't remember how to do certain things in VBA, I often record a macro
doing exactly what I want and then lift that section of the code. Try it.

 

[Bob Phillips]

With ActiveWorkbook.ActiveSheet.Range("G5")
.Formula = "=F5/F15"
.Numberformat = "0%"
End With


--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[SRV....Frenzy]

Hi Bob,

Many Thanks..

Saved a lot of my time,

Cheers,

 

[SRV....Frenzy]

Hi Bob,

Sorry to bother you again,

can you show me how can i sort a column just added to worksheet. It
consists of numbers
Can we not do something like sort for some range
like sort (E5:E15)

can you suggest something...

 

[Bob Phillips]

Range("E5:E15).Sort Key1:=Range("E15"), Order1:=xlAscending,
Header:=xlNo

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)