Limit the number of rows that get copied.

**leaning** · 08-10-2011, 12:20 PM

Hello!

This code copies the values from selected rows of Sheet1 to another sheet ("Labels")

If the Labels destination row is 14 or greater, I don't want the copy operation to work.

What is the best way to modify this code to do that? Maybe even a message box that says "You already have 12 labels prepared on the Label sheet."?

Please Login or Register  to view this content.

I appreciate the help!

Respectfully,

Lost

**JBeaucaire** · 08-10-2011, 01:27 PM

Maybe this:

Please Login or Register  to view this content.

**leaning** · 08-10-2011, 06:03 PM

Sir,

With your code, Row 2 on Sheet1 is being copied to Row 2 on Labels.
Row 3 on Sheet1 is being copied to Row 4 on Labels.
Row 4 on Sheet1 is being copied to Row 6 on Labels.

(It is copying the rows over, but inserting an empty row in-between.)

Any ideas on how to fix this?

Respectfully,

Lost

**JBeaucaire** · 08-10-2011, 06:25 PM

My apologies, this is fixed above:

Please Login or Register  to view this content.

The part in red shouldn't be there.

**leaning** · 08-12-2011, 04:29 PM

Sir,

No need to apologize. The help you provide is always on-point and makes life easier for everyone.

Holds true for this problem. Your code works great!

Thanks,Jerry!

Respectfully,

Lost