Home>

Assuming that the sum of A2: A5 is in A6 and the sum of A8: A14 is in A15, usually in Excel.
When you press the upper right auto SUM on A16, it will automatically enter = SUM (A6, A15)
What can be done to achieve this with VBA?
Is it only possible to search with Find etc.?

vba
  • Answer # 1

    If it is a total, how about using the SUBTOTAL function regardless of VBA?
    = SUBTOTAL (9, A2: A5)for A6,= SUBTOTAL (9, A7: A14)
    If A16 is= SUBTOTAL (9, A2: A15), the same result as sum (A6, A15) will be obtained.

    Is there a mistake in the absence of A7?