Related:
- Assign Value to Variable (Excel VBA)
- Number to words in excel without vba - Guide
- Enable vba in excel - Guide
- Vba case like - Guide
- Excel vba check if value exists in list - Guide
- Excel date format dd.mm.yyyy - Guide
2 responses
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Jun 19, 2010 at 06:31 AM
Jun 19, 2010 at 06:31 AM
for number 1
You can have
CountNumber = WorksheetFunction.Sum(Range("A2:A500"))
for 2
Cells(5, "B") = CountNumber
You can have
CountNumber = WorksheetFunction.Sum(Range("A2:A500"))
for 2
Cells(5, "B") = CountNumber
