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
VBA set thick borders around non empty cells in range 0
Copy user selected range from all open workbooks 2
copying cells from one worksheet to another 1
Checking for non-blank cells in named range 2
Checking for non blank cells in named range 1
Need a UDF to count blank cells 5
Count only cells with red font. 1

Top