title: excel VBA How to insert the same piece of text in more than 1 place in the word document?
body: <p>I have built an excel VBA that</p>
  <ul>
  <li><p>opens a word template</p>
  </li>
  <li><p>get 10 different text/value from my excel sheet (cells)</p>
  </li>
  <li><p>insert those text/value into the word document (from word template) at the 10 bookmarks spot. code: <code>.Bookmarks(&quot;bookmarkname&quot;).Range.Text = text</code> that I want</p>
  </li>
  </ul>
  <p>All these are working well the problem comes when one of the bookmarks called clientNumber, is repeated. It appears once in page1 of the doc and in the headers from page 2 onwards.</p>
  <p>I cant have 2 bookmarks of the same name in the document.
  I googled and tried to make the header's <code>clientNumber</code> cross-reference to the 1st <code>clientNumber</code> bookmark but VBA only inserts text at the bookmark, not at cross-ref.</p>
  <p>So, the main qn is how to insert that same piece of text (eg. <code>12345678</code>) at more than 1 positions in a word document?</p>
  <p>I saw this link: <a href="https://www.msofficeforums.com/word-vba/41654-how-find-if-word-part-cross-reference.html" rel="nofollow noreferrer">https://www.msofficeforums.com/word-vba/41654-how-find-if-word-part-cross-reference.html</a></p>
  <p>but I dont rly understand how it works</p>