Does WorksheetFunction.Sum takes more time?

[lubbamkt]

Hi,

I got a problem when using below code. This procedure is called in another procedure named Grouping. WorksheetFunction.Sum(Range("B2", "B11")) produces 0 when I execute Sub Grouping (I dont know whether this is due to the speed of running). But when I execute solely on this Sub summation right after executing Sub Grouping, this worksheetfunction could produce the correct figure. what is the reason behind? Thanks

Please Login or Register  to view this content.

[HaHoBe]

Hi, lubbamkt,

maybe try

Please Login or Register  to view this content.

Ciao,
Holger

[lubbamkt]

Thanks HaHoBe,

Perfect. Could you tell me what is the rationale behind

Hi, lubbamkt,

maybe try

Please Login or Register  to view this content.

Ciao,
Holger

[HaHoBe]

Hi, lubbamkt,

if you do not qualify a range with a workbook and/or worksheet name VBA assumes this range to be located on the ActiveSheet. As all other actions take place on Worksheets(3) by placing a dot in front of the range makes it part of that worksheet.

Ciao,
Holger