Code to Print single cells
 

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

Code to Print single cells
 

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"



" 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

Code to Print single cells
 

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

" 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