Using a variable for row in (row,column) for a range in VBA
<p>I have a global variable called processRowBegin that contains the row number for the beginning of a process. I also have a global variable called processRowEnd that contains the row number for the end of a process. </p>

<p>What I am trying to do is create a chart for two columns, Columns C and E on the active worksheet, where the range for the selected rows to be plotted is from processRowBegin to processRowEnd. The problem that I am coming across is that I do not know how to use a range with a variable for the row in (row, column) syntax. I have researched this question and so far have not found a solution that works. I tried using the (row,column) syntax at first with the variable names for the row in (row, column). This did not work and resulted in the error in the picture [Using variable for row in range error][1}. </p>

<p>I then tried to implement a solution (code below) that I found via another user's question but still receive the same error. How does one go about doing this in VBA? </p>

<pre><code>Range(("C" &amp; processRowBegin):("C" &amp; processRowEnd)).Select
Range(("E" &amp; processRowBegin):("E" &amp; processRowEnd)).Select
</code></pre>

<p>I am a beginner in Excel VBA as well as programming and would appreciate help. This is my last step to complete an important work project. If anyone would like to view my entire code, please let me know. </p>