Dear Reader
How to amend formula ?
If existing formula is =Round(E1+F1....+Z1,2) , how to amend to
=Round(E1+F1....+Z1,2) + 0.02 ? Where 0.02 is Roundup different value.
This Value range maybe +0.05 to -0.05.

Provide that I does not know the existing formula of particluar cell.

ActiveCell.Formula = ActiveCell.Formula & "+.02"

I have no idea what you mean by "Roundup different value", but hopefully
that won't affect the usefulness of the answer.

--
rEgards,
Tom Ogilvy



"moonhk" <moon_ils-(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Dear Reader
> How to amend formula ?
> If existing formula is =Round(E1+F1....+Z1,2) , how to amend to
> =Round(E1+F1....+Z1,2) + 0.02 ? Where 0.02 is Roundup different value.
> This Value range maybe +0.05 to -0.05.
>
> Provide that I does not know the existing formula of particluar cell.
>

It works. Thank a lot.

=B1+0.02+0.02

Sub testing()
ActiveCell.Formula = ActiveCell.Formula & "+.02"

End Sub

Tom Ogilvy wrote:
> ActiveCell.Formula = ActiveCell.Formula & "+.02"
>
> I have no idea what you mean by "Roundup different value", but hopefully
> that won't affect the usefulness of the answer.
>
> --
> rEgards,
> Tom Ogilvy
>
>
>
> "moonhk" <moon_ils-(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > Dear Reader
> > How to amend formula ?
> > If existing formula is =Round(E1+F1....+Z1,2) , how to amend to
> > =Round(E1+F1....+Z1,2) + 0.02 ? Where 0.02 is Roundup different value.
> > This Value range maybe +0.05 to -0.05.
> >
> > Provide that I does not know the existing formula of particluar cell.
> >