I need help with code to print single cells?? We have a spreadsheet
with bar codes and need to print them on labels with one bar code per
label.

Thanks

Look this up in Excel Help files. It might get you started in the right
direction.

"Print labels by using Excel data in a Word mail merge"



"(E-Mail Removed)" wrote:

> I need help with code to print single cells?? We have a spreadsheet
> with bar codes and need to print them on labels with one bar code per
> label.
>
> Thanks
>
>

hi,
try something like this
Sub Printcell()

Dim s As String

s = ActiveCell.Address
Application.DisplayAlerts = False
ActiveSheet.PageSetup.PrintArea = s
ActiveWindow.SelectedSheets.PrintPreview
ActiveWindow.SelectedSheets.PrintOut Copies:=1
Application.DisplayAlerts = True
End Sub

regards
FSt1

"(E-Mail Removed)" wrote:

> I need help with code to print single cells?? We have a spreadsheet
> with bar codes and need to print them on labels with one bar code per
> label.
>
> Thanks
>
>