Count of non-blank cells.

E

EWill

I am trying to get a count of non-blank cells so that I can use it as
an input to a range. I have tried the following but it only counts
the cells when I manually type something in the cell, not when I copy.

Set myRange = Range("A1.A65536")
myCount = Application.Count(myRange)

Please advise,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adjustment to count cells (in range code) 2
Copy addition formula of non-consecutive horizontal cells 2
Create Sheets from a Range and Copy Data on copy Data on newlycreated Sheets with the Sheet Names 2
Copy user selected range from all open workbooks 2
Need a UDF to count blank cells 5
Count only cells with red font. 1
Excel VBA setting Ranges 3
Eliminate blank row at top of Text Box entries 3

Top