When I try to compile the code all it does is stops at the same spot. S
I dunno if that mean there is something else wrong in the upper part o
the code. All I need it to do is to look for Key words on the firs
sheet "boxes" the take the count and put them on to there own sheets
there are 6 sheets and there are COMetrics FOMetrics WCDMetrics.

GoTo continuation



continuation:

counter = counter + 2
Stops---- ActiveCell.Offset(1, -counter).Select

While (ActiveCell.Value < "")

GoTo continuehere

Wend

GoTo jumpout

Would there be a better way of doing this

--
Message posted from http://www.ExcelForum.com