Assign Value to Variable (Excel VBA) Closed

Question

Hi
I have a variable name CountNumber.
I want it to have a value from the formula "count from A2:A500 range.

How can I write the code in VBA without putting a real formula in excel worksheet.?

2.) Suppose CountNumber already has value.
How can I put the number to a cell, say B5?

rizvisa1 · Answer

for number 1

You can have
CountNumber = WorksheetFunction.Sum(Range("A2:A500"))

for 2

Cells(5, "B") = CountNumber

Kranthi · Answer

for number 1 

You can have 
CountNumber = Range("A2:A500").Rows.Count

Assign Value to Variable (Excel VBA)

2 responses

Similar discussions

Subscribe To Our Newsletter!