Need code to average certain cells

[Alinbuckeye]

Hello, I'm pretty much a VBA novice. I can usually come up with some resolution for my questions in this forum but stuck on this one.
I average response times for emergency vehicles. I've been doing this section by using average formulas manually. Id like to program a code that will select vehicle response times. The problem is this is a month to month moving target.
I want to average the response times for Engine 99, the response times are in column H. This month it could be in H10 - H23, next month H33 - H55.
So I need the code that will mark the beginning match then the last match for Engine99 then average those H columns. I can then use that code for each engine.



Thanks

[Alf]

Perhaps something like this?

Please Login or Register  to view this content.

Not sure about the "NumberFormat" setting, works ok in the Scandinavian environment but you may have to change it to suit your needs.

Alf

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

Places results in Columns J and K.

[Alinbuckeye]

Thanks John. That got me my results. Your a vba guru. Al

[JOHN H. DAVIS]

You're welcome. Glad to help out and thanks for the feedback. Please comply with Forum Rules and mark this thread as SOLVED. See guidelines at the link.

http://www.excelforum.com/forum-rule...rum-rules.html