View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.misc
squenson squenson is offline
external usenet poster
 
Posts: 13
Default Modifying cell references

I never said that you should put in the search and replace boxes what is
*after* the parenthesis of getValue(
Try simply with:
Find What: *!getValue(
Replace with: =getValue(

If you want to do it with a program, simply record a macro when you do the
Search And Replace operation, then look at the code and eventually adapt the
range and run it whenever you want.