Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Select the cells that contain the formula. If they are not together
you can select as big a group as you want to include them all as lon as the ones you don't want changed to not contain an identical searc string. then do Edit=Replace Replace What: 4, FALSE) Replace with: 10, FALSE) Do you formulas really have spaces in them. If so, place them in th search strings so it is an exact match. Anyway, you want to get unique "target" so you don't change things you don't want changed. Leave Find Entire Cells Only unchecked and use Match Case a appropriate. So no code required. -- Regards, Tom Ogilv -- Message posted from http://www.ExcelForum.com |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Find/Replace External Data Web Query | Excel Worksheet Functions | |||
Replace ^ in web query result | Excel Worksheet Functions | |||
How to Delete a Range in Closed Workbook (to Replace Delete Query) | Excel Discussion (Misc queries) | |||
Replace with result of database query, instead of inserting | Excel Programming | |||
Replace ActiveCell w/Query Results? | Excel Programming |