Calculate certain number of Rows in VBA

[tdp3290]

Is there a way to create a VBA function to only recalculate a certain number of rows?

So start with row 1, and create a range.. or something like that, going down 500 rows and then calculate that num of rows (or new range)... and then repeat this going down through thousands of rows... but only calculating about 500 at a time? (and making sure nothing else is recalculated at the same time)

Thanks!

 

[boim]

not tested at all, but maybe something like:

assuming everything start from A1 and on the same sheet:

dim totalrows as integer, iloop as integer, remrows as integer
dim nrows as integer
dim i as integer
dim r as range

nrows=500
totalrows=Range("A1).End(xldown).row
iloop=totalrows \ nrows
remrows=totalrows mod nrows

set r=range("A1")
for i = 1 to iloop-1
range(r, rows(i*nrows))=process something
set r=r.offset(rowoffset:=nrows)
next i
range(r, rows(i*nrows+remrows))=process something