Hello, I have about 100 named ranges that I need to find and replace the #REF with DATA in. Example named range is below.
=#REF!$H$2:INDEX(#REF!$H:$H,Datalrow)
Does anyone have any idea how to do this?
Hello, I have about 100 named ranges that I need to find and replace the #REF with DATA in. Example named range is below.
=#REF!$H$2:INDEX(#REF!$H:$H,Datalrow)
Does anyone have any idea how to do this?
Hi,
try this
Please Login or Register to view this content.
If you are pleased with a member's answer then use the Star icon to rate it.
Not sure if this will work, but you can try using the build-in Find/Replace (which is pretty much what buran has, but you dont need VBA for this)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
@FDibbins: Is it possible to search/replace in the names using the build in dialog?
Of course I know how to display Find/Replace window :-)
Maybe I have wrong understanding of the dcgrove's problem. My understanding is that there are about 100 "named ranges", i.e. names and he/she needs to edit RefersTo property of the name. This is not possible with Find/Replace Window. The alternatives are to edit each name individually in the Name Manager or use VBA. Anyway, there is no feedback from dcgrove...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks