VBA Code

[ds_robb]

Can anyone suggest a useful bit of code that will cross a spreadsheet, starting in cell C5 checking what is in that cell and the one directly below (C6) then skip a cell, move on to E5 and do exactly the same all the way over to the far end of the spreadsheet.

For example

C5 = Tough E5 = Tough G5= Tough
C6 = Nut E6 = Luck G6 = Nut

Bacsically I'm looking via VBA to count the number of occurrances within the spreadsheet of Tough and Nut which in the example above there would be two.

Thanks

 

[VoG]

Something like

For iCol = 3 to 9 Step 2 'change 3 and 9 as appropriate
For iRow = 5 to 6
'your code here
Next iRow
Next iCol

 

[zacemmel]

i=5
Do while i < 256
if cells(5,i).value & cells(6,i).value = "ToughNut" then
number=1 + number
end if
i=i+i
loop

 

[ds_robb]

Thanks, used a combination of both of these answers and it is working perfectly.
Regards
Duncan