View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jim May Jim May is offline
external usenet poster
 
Posts: 477
Default Round(cell,0) after the Fact

Can this be done?

In my sheet All formulas are strictly =Sum()
Is there a MACRO (VBA) that can CHANGE All = Sum()'s formulas
to =Round(Sum(),0) at once ?

If so, could someone share code.
I've been trying now for an hour, but without success
including a google search.
TIA,