Vba for Text string + another cell value + text string
<p>I have a problem. I have simple excel table with pictures that changes number of row every day. I adapted vba code found on internet (I am very new to vba). I wanted to add a string at the first empty cell (last row of the table) and managed that using vba. But the string contains a number that changes every day and I need to update that numer along with the string. The number is number of non empty rows after filter applied and is contained in some cell in the same workbook. How can you make vba that would adapt to what I already have? So it goes like this:
1. Find first empty cell (donne)
2. Select a range from finded cell and merge (donne)
3. Add a text string + number from another cell (the cell contains formula to calculate that number) + another part of text string (this part is my problem)?</p>

<p>Best regard to anyone who can help</p>