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
j = j+1