Applying Selection.numberformat for the whole used Range.

[prabha_friend]

I am having a lot of number columns along with some columns in a worksheet. I want to set the number to "0.00_);[Red](0.00)". But why Excel.Activesheet.usedrange.selection
Selection.numberformat = "0.00_);[Red](0.00)".
I believing there is some thing I have to understand here. Guidance Needed. Thank you.

 

[Brianwarnock]

It should be

Activesheet.usedrange.select

but there is no need to make the selection just

ActiveSheet.UsedRange.NumberFormat = "0.00_);[Red](0.00)"

does it.

Brian