I would like a user to select rows in a worksheet called "Inventory" (they
will be non-continuous) and then create a For..Next loop (or whatever works
best) based on the rows (or just row number), so I can copy and format select
cells from each row in another worksheet called "Labels". I'm not sure how
to do this, either with an array or by looping thru the rows selected. Also,
I need a check so if nothing has been selected they get an error message.

For the selections, will the user need to select the entire row (1:1, 5:5,
7:7, etc) or if they just ctrl select A1, A5, A7, A11, etc will this work too?

Thanks in advance!