Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Labels
I have sth like this from sb very helpful but need to copy also values
from column D as a item description and set number of labels copies even to value in column E for each record ( sheet1 is a base, sheet2 is pattern of label): 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 Can anybody help me with this? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do i create labels so, could only move and type in labels only | Excel Discussion (Misc queries) | |||
Labels | Charts and Charting in Excel | |||
Icons __AND__ labels?! How do I get rid of toolbar LABELS! | New Users to Excel | |||
Getting Labels... | Excel Discussion (Misc queries) | |||
Excel 2003 and Labels (NOT Address Labels) | Excel Discussion (Misc queries) |