Application.CounIf

M

Manish

Hi all,

How can I use a formula in VB to something like:

Application.CountIf(Range(ActiveCell.offset(-
1,0):"A2"),ActiveCell)<>0

To see whether th same text is there in the range i row
above active cell thru A2 with activecell text..

any help?

Thanks

Manish
 
J

JohnI

Manish,

Try something like-

Application.CountIf (Range(ActiveCell.Offset(-1, 0), Range("A2"))) <> 0


regards,

JohnI
 

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

Is Range Offset property needed 1
Code to Concat a row in loop 2
Copy filtered data to sheet 2 1
ActiveCell on inactive sheet 8
Establish if Offset RANGE contains text 11
macro to select a range from a set cell to a specified cell 6
Copy and paste 1
VBA for comparing data within a range for Excel 2003 2

Top