I think what I am trying to do is not that difficult, but I just can't
get it. I have a spreadsheet with a range of H:10 to DD:267 the work
"Pack" appears it is an assignment. I amtry to number each occurence of
"Pack" i.e. Pack1, Pack2 up to Pack41. When the code finds the word I
want it to fill in the next 8 cells to the right with the name Pack and
the incremented number. It should loop through all of the rows
repeating the same pattern until it reachs Pack41, it should then start
over at Pack1 and continue to loop to the end of the range.

Is this very complicated? I'm trying for...next, do until... nothing
works

Thanks

Attachment filename: numberpack.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=411038
---
Message posted from http://www.ExcelForum.com/