Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Bryant Smith   on Sep 20 In MS Office Category.

  
Question Answered By: Lurlene Fischer   on Sep 20

A bit of further research yields a much better answer. All of that
macro below can be replaced with just one line:

cells.SpecialCells(xlFormulas).Select

The equivalent manually  is:
Make sure no multicell range is selected (that would restrict the
resultant selected cells to within that multicell selection)
Edit dropdown menu|Go to...
Click the Special button
Select Formulas, (leave all checks in place)
Click OK
THEN do your find/replace.

Share: 

 

This Question has 4 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on searching within formulas Or get search suggestion and latest updates.


Tagged: