Hello.
I'm trying to replace considering the situation above:
If the content of column B (Navette.Sheet) = Yes And name of the cell in column B (Navette.Sheet) equal to the content of column D (Replace Workbook - Clause Sheet) then
Replace the bookmarks considering the content of column F (Replace Workbook - Clause Sheet) Else do Nothing
I'm trying to replace considering the situation above:
If the content of column B (Navette.Sheet) = Yes And name of the cell in column B (Navette.Sheet) equal to the content of column D (Replace Workbook - Clause Sheet) then
Replace the bookmarks considering the content of column F (Replace Workbook - Clause Sheet) Else do Nothing
VBA Code:
[/
With wordDoc
Dim bm As Bookmark
If Navette.Range("A" & row).Value = "Yes" And Navette.Range("B" & row).Name) = Replace.Sheet("D" & row) Then
For Each bm In ActiveDocument.Bookmarks
ActiveDocument.Bookmarks (Replace.Range("F" & row).Value)
Else
Nothing
On Error Goto Next
Next
]
But I'm getting error, can someone help?