There's a learning curve with each language. You have to learn how to write
your If statements.

If Cells(i, "F").Value AND(=5,=<7) Then

This looks like you tried to use excel's worksheet function =and().

In VBA, you have to use its rules.

If (Cells(i, "F").Value = 5 _
And Cells(i, "F").Value <= 7) Then

You may want to invest in a book.

Debra Dalgleish has a list at her site:
http://www.contextures.com/xlbooks.html

John Walkenbach's is a nice one to start with. See if you can find them in your
local bookstore and you can choose what one you like best.

Daminc wrote:

Excellent Dave. That works perfectly. :)

Is there any chance that you might explain where I went wrong and why
it was wrong (just to stop me from making the same mistake twice)

Thanks.

--
Daminc
------------------------------------------------------------------------
Daminc's Profile: http://www.excelforum.com/member.php...o&userid=27074
View this thread: http://www.excelforum.com/showthread...hreadid=465603

--

Dave Peterson