PDA

View Full Version : need loop code



mdraddy
02-01-2008, 01:04 PM
I need code that will loop a selection I choose in column I on Sheet 1, and return to Cell L3 on Sheet 3 the number of times the value ?CAM? appears in that selection. Thanks!

Bob Phillips
02-01-2008, 02:05 PM
Why use code, why not a formula

=COUNTIF(Sheet1!I10:I20,"CAM")