Need to add text in existing formula

[mdd16]

Hi there,

I need some help in my code. I need to add additional components in the existing formula of a cell.. I am able to build string to be added with VBA.

The addition is at place which is 8 characters from behind. Screen shot is attached to show formula with added string and original formula

Any help will be highly appreciated..

MOHAN DHINGRA

 

[Legacy 143009]

Example for A1 cell:

Range("A1").Formula = Left(Range("A1").Formula, Len(Range("A1").Formula)-9) & "+RC[22]*RC[23]" & Right(Range("A1").Formula, 9)

 

[mdd16]

Hi .. thanks for your quick response.

I am getting an error when I implemented the suggested code. Attached file shows the error and my steps.

Thanks again for your kind help..

 

[Legacy 143009]

I don't know your data. Maybe you should try -9 instead of -8. Maybe excel isn't accepting as valid formula.

 

[mdd16]

I don't know your data. Maybe you should try -9 instead of -8. Maybe excel isn't accepting as valid formula.

Hello .. I solved it.. the error was because of range method. I had already set mAncr2 as a range and then I was adding word .. as in... Range(mAncr2) again.

Thanks so much for your help

 

[Legacy 143009]

Glad you managed it. Thanks for the feedback