title: Excel Button Issues
body: <p>I made a very simple macro that adds a column to the end of table with concatenated values, there is no issue when i click on the vba button.<a href="https://i.stack.imgur.com/m2StU.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/m2StU.png" alt="enter image description here" /></a></p>
  <p>However an issue arises when I assign a macro to the button on a separate workbook, it fails to fill all the rows with the correct values. (See black circle on Image)
  <a href="https://i.stack.imgur.com/lVCmG.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/lVCmG.png" alt="enter image description here" /></a></p>
  <p>My code is below</p>
  <pre><code>  sub OrganizingResearchTracker()
      
      'Variables
      Dim lr As Long
      lr = Cells.Find(&quot;*&quot;, Cells(1, 1), xlFormulas, xlPart, xlByRows, xlPrevious, False).Row
      
      Dim tbl As ListObject
      Dim wbNames As Variant, wb As Workbook, w As Workbook, El As Variant, boolFound As Boolean
      
        wbNames = Split(&quot;January,February,March,April,May,June,July,August,September,October,November,December&quot;, &quot;,&quot;)
        For Each w In Workbooks
          For Each El In wbNames
              If w.Name = &quot;Completed Research Docs_Tracker_&quot; &amp; El &amp; &quot; 2020.xlsm&quot; Then
                  Set wb = w: boolFound = True: Exit For
              End If
          Next
          If boolFound Then Exit For 'in order to stop iteration if a lot of workbooks are open
           Next
      
      '1. Column AB - Descriptive Field - Client Name - Manager Name - Research Deliverable
      
      wb.Activate
      Set tbl = ActiveSheet.ListObjects(&quot;Table_owssvr&quot;)
      With tbl
              .ListColumns.Add.Name = &quot;Client Name - Manager Name - Research Deliverable&quot;
      End With
      
          Range(&quot;AB2:AB&quot; &amp; lr).FormulaR1C1 = &quot;=CONCATENATE(RC[-22],&quot;&quot; - &quot;&quot;,RC[-26],&quot;&quot; - &quot;&quot;,RC[-15])&quot;
  end sub
  </code></pre>
  <p>Anyone had this issue and know how to amend it? thank you</p>