VBA Express Forum
>
VBA Code & Other Help
>
Excel Help
> need loop code
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")
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.