Combining an row index(variable) with a column in VBA

Question

I have already found the row index of a cell using VBA code. But I now I need to find an average of values in the cells from an index to another index. To find average, I know i can use application.worksheetfunction.average() but how do I combine the column and row index. The row index is a variable while the column is B for example.

For example, I need to find the average between startIndex to endIndex

Code:application.worksheetfunction.average("BstartIndex:BendIndex").

Is this right?

ApplePie · Accepted Answer · 2014-03-30 22:16:44Z

2

Application.WorksheetFunction.Average("B" & startIndex & ":B" & endIndex)

Basically, what you want to do is concatenate all components of the range string to insert into the function call. You cannot refer to variables inside a string in VBA, to my knowledge.

answered Mar 30, 2014 at 22:16

ApplePie

8,9525 gold badges41 silver badges62 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Combining an row index(variable) with a column in VBA

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related