Plot in VBA Using Variable
<p>So here is the code that I am working with: </p>

<pre><code>c = Application.Match("Test", Range("F1:F130"), 0)        
    ActiveChart.SeriesCollection(1).XValues = "='" &amp; shtname &amp; "'" &amp;  "!$B$104:$N$104"
</code></pre>

<p>So similar to the plot I would want to be able to say because c+4 = some integer which is not always 104. </p>

<pre><code>ActiveChart.SeriesCollection(1).XValues = "='" &amp; shtname &amp; "'" &amp;  "!$B$(c+3):$N$(c+3)"
</code></pre>

<p>I have tried using doing something like: </p>

<pre><code>ActiveChart.SeriesCollection(1).XValues = "='" &amp; shtname &amp; "'" &amp; "!$B$" &amp; " (c+3):$N$" &amp; " (c+3) "
</code></pre>

<p>This did not work... obviously, but I am very new to VBA and the syntax, so any help is appreciated. 
Here is the function for shtname as well: </p>

<pre><code>    Function shtname() As String
    shtname = ActiveSheet.Name
    End Function
</code></pre>