How to return sum of a range with fixed starting cell and variable length

[jaskeerat]

Hi,

I am trying to write a macro where I have offset from a cell and then make a range by going down rows and have to repeat that multipe times.

SO my starting point is fixed. in Excel term its will be like '=sum(offset("start",0,p,q)

Start is name of fixed cell and p and q are variables.
How can I do this in VBA?

[TMS]

An example:

Please Login or Register  to view this content.

Based on data in column A with a heading in row 1.

Regards

[Bob Phillips]

Please Login or Register  to view this content.

[jaskeerat]

HI Bob

I am offsettting by p columns and then stratching bt q rows

SO would my code be application.sum(range("start").offset(0,p).resize(q,0)) ?

[jaskeerat]

|Sorry that wld be (q,1)

Thanks a lot!!!