Home Range(variable).Value - - Loop
 Can anybody help me with a simple question. I try to apply filters to a pivot, such that I generate some values, after which I store them somewere else. I need to iterate through cells C7 to C100, as each will create a set of different values. I know how to refer to a specific cell in my code:  CurrentPage = Range("C7").Value  How can I refer to column C, however the number "7" in the case above to be referend as a variable e.g Dim j as Integer j = 7 after loop j = j+1