title: Excel Column delete using VBscript
body: <p>I wrote a code in vbscript as below ,but when i run my script it is giving an error saying the "Range" is undefined. Can any help me here by saying what is the error?</p>
  
  <pre><code>For TaskCounter = 1 to 35    
    TaskRangeFrom="Task"&amp;TaskCounter&amp;" Start Date"    
    TaskRangeTo="Task"&amp;(TaskCounter+1)&amp;" Name"    
    objSheet6.Range(Range(TaskRangeFrom).Offset(,1), _ 
    Range(TaskRangeTo).Offset(,-1)).EntireColumn.Delete
  Next 
  </code></pre>
  
  <p>Thanks in advance.</p>