VBA: Sum Across Range with Missings

[jcauteru]

Hi all,

I have the following code to sum across a specific range:

 total_sum = Application.WorksheetFunction.Sum(Range(Cells(row_num, start_col), Cells(row_num, end_col)))

As you can see, this line is trying to take the sum of a single row of cells, from start_col to end_col. Problem is, it errors out when trying to sum up a row with any blank cells.

Any thoughts or ideas? Any help is much appreciated!

Best,
Joe

 

[Domenic]

Blank cells within the range should not generate an error? Which error are you getting? What values do each of the variables holds when executing that line of code?

 

[RSXchin]

works for me.

 

[jcauteru]

Yea, it was actually a really simple problem. There where some "do while <> "" " loops going on and an analyst decided to change a column number to the wrong column, which had blanks.

Thanks for your input!

- Joe

 

[Domenic]

That's great. Glad you've sorted it out.