I will try to explain this as best as possible. Beginning VBA user and
have excel 2003. What I would like to do is this.

I need code to look at a field in a row, for example

If activecell.offset(0,5).value = yes then
"msg box to ask a question if it wants to print out"
End If


My problem is the following.

I have sheet1

Row 20 = Original 4 oz
Row 21 = Original 9 oz
Row 22 = Original 20 oz
Row 23 = Original 48 oz


The code loops thru each row and checks to see if
activecell.offset(0,5).value = yes
If yes then it prompts for printout with a message box.

This works great if I only have 1 item.

But for the above situation I don't want the message box to prompt for
the printout until it has looped thru the last of the group (in this
case Original 48 oz). Then prompt for a message box


Sorry for the lousy explanations.


I would appreciate any help

thanks Josh


--
jhahes
------------------------------------------------------------------------
jhahes's Profile: http://www.excelforum.com/member.php...o&userid=23596
View this thread: http://www.excelforum.com/showthread...hreadid=472190