View Full Version : [SOLVED:] Find / Replace with Name Range References
Anne Troy
10-09-2005, 06:21 PM
I've checked the KB and either it doesn't exist, or I am misunderstanding.
What I want to do is take, for instance:
=Report!H7
and replace with...
=ValuationDate
Throughout an entire workbook.
johnske
10-09-2005, 09:09 PM
Sub ReplaceIt()
Dim Sheet As Worksheet
For Each Sheet In Worksheets
Sheet.Activate
Cells.Replace What:="=Report!H7", Replacement:="=ValuationDate", _
SearchOrder:=xlByColumns, MatchCase:=True
Next Sheet
Set Sheet = Nothing
End Sub :)
Anne Troy
10-10-2005, 08:11 AM
Terrific!! Please add to the KB. :)
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.