Replace ' with =

[Shefali]

Need to replace 'Sheet!7 with =Sheet!7. Find and Replace
does not work.

 

[Frank Isaacs]

Try searching for Sheet instead of 'Sheet.

The ' is used to tell Excel to treat the contents of text, but isn't found
in the search.
--
HTH -

-Frank Isaacs
Dolphin Technology Corp.
http://vbapro.com

 

[Don Guillett]

try
for each c in selection
c.value="="&right(c,len(c)-1)
next