Macro: Search and replace: Replace using a cell reference

[kalyan46]

Hello all
need some help on the replace portion of this code. Would like to use a cell reference instead of a flat number. Cell reference would be Sheet1 Cell E16

Please Login or Register  to view this content.

[protonLeah]

Please Login or Register  to view this content.

[kalyan46]

Hello
I am a getting an error, each time I type in Option Explicit, it goes into the macro before this one. Also changed Sheet1 with RunProcess

SearchVal = runprocess.Range("E16").Value

Please Login or Register  to view this content.

[protonLeah]

"...runprocess.Range("E16").Value..."
RunProcess is not an Excel Object, but the name of a particular SHEETS Object

Please Login or Register  to view this content.