Rounding Values

[Marcus]

Does any one know how to round cell values down using vb
code.

I am trying to round down values such has 25.95456465 to
25 using a loop command. But cannot find any example in
any of my books.

Plese help

 

[Frank Kabel]

Hi
see:
http://www.xldynamic.com/source/xld.Rounding.html#vba

 

[Tom Ogilvy]

for each cell in selection
if isnumeric(cell) then
cell.value = int(cell.value)
end if
Next

 

[Guest]

Thanks Tom

-----Original Message-----
for each cell in selection
if isnumeric(cell) then
cell.value = int(cell.value)
end if
Next

--
Regards,
Tom Ogilvy





.