Using CountA on one row ONLY and also using the cells found and putting them somewhere else
<p>So I am learning VBA, I know how to program on Matlab and some C++. I am wondering how I can use the CountA to count all of the cells used on a specific row and only that row. ( I have multiple examples on ranges and columns but none on a Row only).I cannot use a range because I want to use this VBA in the future and this row will have a number of variables changing. I would also like to have the content(text) of those cells moved to another location with no spaces between them because right now they have three spaces between each used cell.</p>

<p>So far I have this code which isn't very much for the countA of the first row </p>

<pre><code>Sub CountNonBlankCells()
    Dim numcompanies As Integer
    n = Sheet1.CountA(Rows(1))
    Worksheets("start on this page").Range("B2") = n
End Sub
</code></pre>

<p>I have nothing for the part where I take that data from each cell to another location.</p>