LtCmdrData
Board Regular
- Joined
- Jan 24, 2018
- Messages
- 58
- Office Version
- 365
- Platform
- Windows
I have 2 columns of data - first column is item and the second column is the count of that item. The number of rows will vary each time the report is run. I have vba code to place "Grand Total" in row 4 of column Q. I need vba code to sum the total of the second column starting in row 5 and going down a dynamic range and place that total in row 4 of column R so it lines up with the Grand Total. Is there a way to utilize CurrentRegion? I appreciate any help someone could offer. Thanks.
Book1 | ||||
---|---|---|---|---|
Q | R | |||
4 | Grand Total | SUM goes here | ||
5 | A | 959,973 | ||
6 | B | 338,125 | ||
7 | C | 241,641 | ||
8 | D | 156,772 | ||
9 | E | 50,232 | ||
10 | F | 37,352 | ||
11 | H | 25,080 | ||
12 | I | 18,785 | ||
13 | J | 13,223 | ||
14 | K | 11,204 | ||
15 | L | 9,735 | ||
16 | M | 6,361 | ||
17 | N | 5,748 | ||
18 | O | 4,266 | ||
19 | P | 4,214 | ||
20 | Q | 4,180 | ||
21 | R | 4,145 | ||
22 | S | 3,956 | ||
Sheet1 |