1. I have a range of cells filled with number from E8 to the last filled cell.
How to summing in "one shot" the range of cells and store the result in a var as long with 2 decimal number?

2. I have a range of cells filled with number from E8 to the last filled cell.
How to summing in "one shot" the range of cells and store the result in a var as long with 2 decimal number?

3. I have a range of cells filled with number from E8 to the last filled cell.
How to summing in "one shot" the range of cells and store the result in a var as long with 2 decimal number?

4. I have a range of cells filled with number from E8 to the last filled cell.
How to summing in "one shot" the range of cells and store the result in a var as long with 2 decimal number?

5. I have a range of cells filled with number from E8 to the last filled cell.
How to summing in "one shot" the range of cells and store the result in a var as long with 2 decimal number?

6. I have a range of cells filled with number from E8 to the last filled cell.
How to summing in "one shot" the range of cells and store the result in a var as long with 2 decimal number?

7. I have a range of cells filled with number from E8 to the last filled cell.
How to summing in "one shot" the range of cells and store the result in a var as long with 2 decimal number?

8. I have a range of cells filled with number from E8 to the last filled cell.
How to summing in "one shot" the range of cells and store the result in a var as long with 2 decimal number?

9. Dim lVar As Long
lVar = Round(Application.WorksheetFunction.Sum(Range(Rang e("E8"), Range("E" & ActiveSheet.Rows.Count).End(xlUp))), 2)

Steve

10. Dim lVar As Long
lVar = Round(Application.WorksheetFunction.Sum(Range(Rang e("E8"), Range("E" & ActiveSheet.Rows.Count).End(xlUp))), 2)

Steve

11. Dim lVar As Long
lVar = Round(Application.WorksheetFunction.Sum(Range(Rang e("E8"), Range("E" & ActiveSheet.Rows.Count).End(xlUp))), 2)

Steve

12. Dim lVar As Long
lVar = Round(Application.WorksheetFunction.Sum(Range(Rang e("E8"), Range("E" & ActiveSheet.Rows.Count).End(xlUp))), 2)

Steve

13. Dim lVar As Long
lVar = Round(Application.WorksheetFunction.Sum(Range(Rang e("E8"), Range("E" & ActiveSheet.Rows.Count).End(xlUp))), 2)

Steve

14. Dim lVar As Long
lVar = Round(Application.WorksheetFunction.Sum(Range(Rang e("E8"), Range("E" & ActiveSheet.Rows.Count).End(xlUp))), 2)

Steve

15. Dim lVar As Long
lVar = Round(Application.WorksheetFunction.Sum(Range(Rang e("E8"), Range("E" & ActiveSheet.Rows.Count).End(xlUp))), 2)

Steve

Page 1 of 3 123 Last

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•