Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Printing single pages from multiple worksheets in a single print job | Excel Discussion (Misc queries) | |||
single print job generates many print jobs | Excel Discussion (Misc queries) | |||
Copy column range of "single word" cells with spaces to a single c | Excel Discussion (Misc queries) | |||
Single file won't print | Excel Discussion (Misc queries) | |||
Print Single Statement Help PLEASE! | Excel Programming |