Find replace in functions

[Guest]

Is it possible to use find and replace in functions?

For example, I have a function repeated through out a sheet that is a
Vlookup to return the values in ('EU into US VLOOKUP'!$Q:$Q) but I want to
return the values in $R:$R...is there a way to do a find and replace all Qs
with Rs?

 

[Aqib Rizvi]

Find and replace works with all, Formulas, Values and Comments. You
need to choose what you are looking into from the dialogue box. Click
on Options in the dialogue box (when you see if after pressing CTRL+H)
and then choose from "Look into".

AQIB RIZVI

 

[MartinW]

Hi,

That option is not available in the Excel 2000 find and replace box.

In 2000 you need Edit>Goto>Special Button, first, to select your
formulae and then do your find and replace.

Shortcuts for Edit>Goto are Ctrl+G or F5

HTH
Martin