What's wrong with this ??

  • Thread starter Thread starter Eric @ BP-EVV
  • Start date Start date
E

Eric @ BP-EVV

Can anyone tell me why I get an error when I attempt the following code ?

rcount10 = Application.WorksheetFunction.CountIf(Worksheets("working
data").Range("K1:K65536"), "No")

Thanks !
 
I don't recall the error message exactly...something about a failure on range
select. I have since added the following two lines before that code and now
it works fine:

Worksheets("working data").Activate
Worksheets("working data").ActiveCell ("A1:A1")

Thanks anyway !
 
Activating the worksheet shouldn't make any difference, and that second line
is invalid syntax, so it doesn't work anyway, I don't know how you can think
it has fixed the problem.
 
You must log in or register to reply here.

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

My code need to go on a diet 10
Stuck with multi function Part 2 28
VBA Countif across sheets? 5
VB code stalls when file is shared 2
Adding a condition to VBA CountIF 7
ERROR 400 on identical codes different range 8
Macro Help 4
help needed with Countif.... 4

Back
Top