Thread: Late Rounding of Formula
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
 
Posts: n/a
Default Late Rounding of Formula
Possibly a little cludgy but this code snippet should work

for each cell in range(whatever)
cell.Formula = "=round(" & Right(cell.Formula, Len(cell.Formula) -
1) & ",2)"
next

Reply With QuoteReply With Quote