GetCellValue - Sum instead

[jamescooper]

Hello,

How would I alter the following code so that I could get the sum of F12:H12, rather than just the exact cell H12?

destcell1.Offset(r, 0).Value = GetCellValue(folderPath & fileName, "Forecast", "H12")

Many thanks.

 

[Eric W]

GetCellValue is not a built-in VBA function, so we don't know what's in it. If you have access to the source for that function, you can change it there. If you don't have access to that function, you'd have to do something like:

    destcell1.Offset(r, 0).Value = GetCellValue(folderPath & Filename, "Forecast", "F12") + _
                                   GetCellValue(folderPath & Filename, "Forecast", "G12") + _
                                   GetCellValue(folderPath & Filename, "Forecast", "H12")

 

[jamescooper]

GetCellValue is not a built-in VBA function, so we don't know what's in it. If you have access to the source for that function, you can change it there. If you don't have access to that function, you'd have to do something like:

    destcell1.Offset(r, 0).Value = GetCellValue(folderPath & Filename, "Forecast", "F12") + _
                                   GetCellValue(folderPath & Filename, "Forecast", "G12") + _
                                   GetCellValue(folderPath & Filename, "Forecast", "H12")

Thanks Eric, sadly that doesn't quite work.

Any other ideas?

Thanks.

 

[Eric W]

Thanks Eric, sadly that doesn't quite work.

Why doesn't it work? Wrong result? Error? If so, what? Are you looking for an arbitrary sum instead of the specific F12:H12? Is the other workbook you're trying to access open or closed?

My original statement stands: without access to the GetCellValue function, we're shooting in the dark. If you want to sum an arbitrary range, you could put the function in a loop, and create the individual cell addresses on each pass. The last option would be to assume that the function merely gets the value of a cell in another workbook, and then write your own function to do the same, allowing for the sum of a range instead of a single cell.