Skip to Content
Former Member
Jan 06, 2016 at 12:06 PM

Range.Find and Range.Replace functions in BPC NW 7.50 SP18


Dear Experts,

We have just upgraded from BPC NW 7.50 SP14 - Excel 2010 to BPC NW 7.50 Sp18 with Excel 2013.

While testing the upgraded system we found that after opening few input schedules, EvDRE Expand stopped working and we encountered navigation issues.

On debug, found that the issue was with few lines of code that had "Range.Find and Range.Replace" excel functions used.

When these lines were commented, the schedules worked fine without any issue. Hence, we had to find some workaround to avoid the usage of these functions.

We tried to find some information/documents regarding the same but were unsuccessful.

Can anyone help us to know if this is a compatibility issue of these functions with BPC NW 7.50 SP18?

Or are there any other reasons for this strange behavior?

Many Thanks,