When I run the following against a single word, it runs fine, but I need to run it against a two-word phrase. I'm getting a bug when I try.
Sub B_ReplaceHeaders()
'Replace Last Name with LAST_NAME
Dim LastName As String
Dim LAST_NAME As String
'Replace First Name with FIRST_NAME
Dim FirstName As String
Dim FIRST_NAME As String
LastName = Range("A1").Value
LAST_NAME = Replace("Last Name", "Last Name", "LAST_NAME")
FirstName = Range("B1").Value
FIRST_NAME = Replace("First Name", "First Name", "FIRST_NAME")
Range("A1").Offset(, 0).Value = LastName
Range("B1").Offset(, 0).Value = FirstName
End Sub
Any ideas on how I might account for the space in the search string?
Bookmarks