title: Defining a range using a variable integer in VBA
body: <p>So here is my problem. I know we can define a range in VBA, say for example like 
  Range("A1:A300"). Now say I have some integer x. I want the range from A1 to Ax. How can I write this in a code? Range("A1:Ax") clearly does not work</p>