Home Range(variable).Value - - Loop
Reply: 0

Range(variable).Value - - Loop

user576
1#
user576 Published in July 20, 2018, 4:50 am

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
You need to login account before you can post.

About| Privacy statement| Terms of Service| Advertising| Contact us| Help| Sitemap|
Processed in 0.320037 second(s) , Gzip On .

© 2016 Powered by mzan.com design MATCHINFO