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.?
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?
- vba - i want to display only the cells containing values in a list
- error in vba split function
- vba - i want to pass the value entered in the combo box to the dir function
- how to make vba "undo" function?
- vba - i want to move only the bold cells to the a column when the bold cells and the ordinary cells are mixed in the b column
- vba - excel count function
- about sheets function error in vba
- (vbnet) i want to get the value value of a cell containing an excel function with closedxml
- function - how to make importrange recognize the cells on the same sheet
- i want to use the function of vba function "filedialog" on mac
- vba - macro to color the cells on change event
- i want to create a vba function in gas and make it work
- vba - i want to update only blank cells
- convert excel vba cells to range
- vba - i want to copy the results filtered by the filter to the cells of another sheet, one cell at a time
- questions about vba's weekday function
- i want to make cells visible/invisible using excel vba
- i want to solve that the defined function cannot be used in vba function
- i want to rewrite a function in a vba cell but get a syntax error
- i want to save a file using the urldownloadtofile function in excel vba, but the file is broken and it does not work
- php - coincheck api authentication doesn't work
- php - i would like to introduce the coincheck api so that i can make payments with bitcoin on my ec site
- [php] i want to get account information using coincheck api
- python - you may need to restart the kernel to use updated packages error
- python 3x - typeerror: 'method' object is not subscriptable
- the emulator process for avd pixel_2_api_29 was killed occurred when the android studio emulator was started, so i would like to
- xcode - pod install [!] no `podfile 'found in the project directory
- vuejs - [vuetify] unable to locate target [data-app] i want to unit test to avoid warning
- android studio - unresolved reference comes out in kotlin