Excel VBA - Rounding highlighted cells

R

robert cohen

Is there a macro that can be used to round, say to 2 decimal places,
number of highlighted cells, say a column
 
F

Frank Kabel

Hi
you may try the following code:

sub foo()
dim rng as range
dim c as range
set rng = selection
for each c in selection
if IsNumeric (c.value) then
c.value = Round(c.value,2)
end if
next
end sub

Highlight your column and invoke this macro
 
Top