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?

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

Hi,

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

In 2000 you need EditGotoSpecial Button, first, to select your
formulae and then do your find and replace.

Shortcuts for EditGoto are Ctrl+G or F5

HTH
Martin




"Aqib Rizvi" wrote in message
...
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