Require Correct Syntax using .Formula = "=Substitiute...." between two sheets

[NimishK]

Hi

Can anyone help me with correct syntax for the following

ActiveSheet.Range("B1").Formula = "=SUBSTITUTE(A1,TRIM(RIGHT(SUBSTITUTE(A1,""."",REPT("" "",255)),255)),TRIM(RIGHT(SUBSTITUTE(A1,""."",REPT("" "",255)),255))+1)"

Instead of using ActiveSheet. Range would like to use Sheet1 and get the incremment value of IP add in sheet2



Thanks
NimishK

 

[NARAYANK991]

Hi ,

Something like this :

Sheet1.Range("B1").Formula = "=SUBSTITUTE(Sheet2!A1,TRIM(RIGHT(SUBSTITUTE(Sheet2!A1,""."",REPT("" "",255)),255)),TRIM(RIGHT(SUBSTITUTE(Sheet2!A1,""."",REPT("" "",255)),255))+1)

 

[NimishK]

Thankx Narayan.

It was just perfect