Code to Print single cells

  • Thread starter Thread starter ianmacinnis
  • Start date Start date
I

ianmacinnis

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"
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Quick Access Tool Bar 1
Datamatrix ActiveX control 1
Frame control scroll bar 0
Using J1.value to print single label 4
Application.SendKeys & Printing 1
Copy cell change to other workbook 5
VBA userform Vlookup Excel 1
VBA set thick borders around non empty cells in range 0

Back
Top