Please TOP post for readability. Then try this.
Sub CommandButton1_Click()
lr=cells(rows.count,"c").end(xlup).row
for each c in range("C1:C" & lr)
If C.Value <>"" Then
c.Copy Sheets("Sheet2").range("E3")
sheets("sheet2").PrintOut
End If
Next C
End sub

Signature
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett1@austin.rr.com
On 31 Lip, 14:27, "Don Guillett" <dguille...@austin.rr.com> wrote:
> You really should do this using data>filter>autofilter>non
> blanks>copy>paste
[quoted text clipped - 51 lines]
> > print label but it returns me error when refering to 2nd sheet. Can
> > anyone help me with this?
I wrote it in button's code and returned me error in line:
Range("B1").Select ("Method Select from class Range didn't work").
What's more i want to make a loop using this reference- to print a
label for every item mentioned in Sheet1.Column C
dario90@gmail.com - 31 Jul 2008 14:20 GMT
> Please TOP post for readability. Then try this.
>
[quoted text clipped - 77 lines]
> What's more i want to make a loop using this reference- to print a
> label for every item mentioned in Sheet1.Column C
Ok, great. Thank you. One more issue: when i have in column D notes
about items in C and want to print it on the same label - is another
For... needed?
Don Guillett - 31 Jul 2008 14:34 GMT
Perhaps you didn't understand my request to TOP post.

Signature
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett1@austin.rr.com
On 31 Lip, 15:07, "Don Guillett" <dguille...@austin.rr.com> wrote:
> Please TOP post for readability. Then try this.
>
[quoted text clipped - 77 lines]
> What's more i want to make a loop using this reference- to print a
> label for every item mentioned in Sheet1.Column C
Ok, great. Thank you. One more issue: when i have in column D notes
about items in C and want to print it on the same label - is another
For... needed?
dario90@gmail.com - 31 Jul 2008 14:44 GMT
> Perhaps you didn't understand my request to TOP post.
>
[quoted text clipped - 92 lines]
> about items in C and want to print it on the same label - is another
> For... needed?
Maybe- what did you mean?