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

Range(variable).Value - - Loop

victorj
1#
victorj Published in 2018-01-12 16:37:46Z

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
QHarr
2#
QHarr Reply to 2018-01-12 16:40:23Z

Something like (note that the For Loop increments j)

For j = 7 To 100
   Activesheet.Cells(j,"C") ......
Next j
You need to login account before you can post.

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

© 2016 Powered by mzan.com design MATCHINFO