UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> Search for strings    
 
   
David494
post Jul 28 2005, 10:41 PM
Post #1

UtterAccess Member
Posts: 43
If I use the line of code (not using vba).......
=COUNTIF(R1C1:R36C1,"COUNCIL TAX - General queries")

........ then it works fine.

However if i put this into vba using a macro then it doesn't work.

Application.WorksheetFunction.CountIf(range("R2C1:R35C1"), "COUNCIL TAX - General queries*")


Totally stuck here,

Will keep trying, but does anyone understand this

Thanks Guys.

Dav
Go to the top of the page
 
+
David494
post Jul 29 2005, 12:06 AM
Post #2

UtterAccess Member
Posts: 43
i just put this out to a msgbox and it seems to work fine now
Go to the top of the page
 
+
« Next Oldest · Microsoft Excel · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 24th May 2013 - 04:32 AM