Assign Value to Variable (Excel VBA)

Closed

tor - Jun 18, 2010 at 11:06 PM
Kranthi - Jun 22, 2010 at 01:24 AM

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?

Assign Value to Variable (Excel VBA)
Number to words in excel formula without vba - Guide
Vba case like - Guide
How to open vba in excel mac - Guide
Excel vba check if value exists in list - Guide
Excel marksheet - Guide

2 responses

Answer 1 / 2

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
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

Answer 2 / 2

Kranthi
Jun 22, 2010 at 01:24 AM

for number 1

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

Similar discussions

Date formatting in dd/mm/yyyy

Create folder in desktop with vba, if exist, ignore

Similar discussions

Subscribe To Our Newsletter!