Runtime error 1004 on an application.count statement

  • Thread starter Thread starter PhilM
  • Start date Start date
P

PhilM

Monthrange = Application.CountIf(Sheets("inpatient data").Range("R" &
essstart & "r:" & ESSend), Monthvalue(Monthdataloop))

Having problems with the above statement

Values as follows

essstart = 44405
essend = 52346
Monthvalue = April (as string)

Can anyone spot anything obvious?

Having to do the count to determine how many entries per month to find
out where each month starts. Application.match reuturned the same error
 
& "r:" &

Maybe:

& ":r" &

--
Jim
| Monthrange = Application.CountIf(Sheets("inpatient data").Range("R" &
| essstart & "r:" & ESSend), Monthvalue(Monthdataloop))
|
| Having problems with the above statement
|
| Values as follows
|
| essstart = 44405
| essend = 52346
| Monthvalue = April (as string)
|
| Can anyone spot anything obvious?
|
| Having to do the count to determine how many entries per month to find
| out where each month starts. Application.match reuturned the same error
 
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

Struggling to make an application.count work 2
Runtime Error 1004 on Linest 7
Runtime Error 1004 on Linest in VBA 1
Runtime error 1004 application-defined or object-defined error 2
FWT Newsletter - Weekly - November 1, 2004 0
FWT Newsletter - Weekly - January 5, 2004 3
FWT Newsletter - Weekly - September 13, 2004 1
FWT Newsletter - Weekly - November 17, 2003 0

Back
Top