title: Excel macro row variable
body: <p>I am trying to make an excel macro. How can i make rows variable? It must increase as A6,A7,A8...
  I know making colums variable but can't do it for rows.
  Here are a few lines from the code.</p>
  
  <pre><code>For profnum = 1 To 100
      Range("A6").Select.Offset(1 + (profnum - 1) * 1, 0).Select
  </code></pre>
  
  <p>And i have over 100 graph profiles. Every profile has x and y values. And i changed  124(number of x and y values) as 504 as seen below. But repeating that 200 times or 500 times is very hard and takes too long time. How can i make it by a macro?</p>
  
  <pre><code>=SERİLER("file44.txt";main_excel!$ED$4:$ED$504;main_excel!$EE$4:$EE$504;45)
  </code></pre>