Hi
Can anyone help me with correct syntax for the following
Instead of using ActiveSheet. Range would like to use Sheet1 and get the incremment value of IP add in sheet2
Thanks
NimishK
Can anyone help me with correct syntax for the following
Code:
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