Printing by using a vba code

Hot Topic

How to create a DLL in VB.net for MS Access 2003
Excel edit mode
compiler for VBA application?
When to program in VBA and when not to???
Excel - squares appear when sending info from textbox to cell
MS Office document and image writer print driver
VB 6...
Application Error
Excel, Forms, and Charts
VBA Code to save Excel w Name including cell data

Microsoft ISV

Scroll Events of mouse
VBA tapi caller ID
Collections Class For Each Next
Suppress Linked View Unique Record Popup
VBA in Office 12
Reading data dll into excel
cannot save file as
Someone mind helping me with Error 426
Setting ASP.NET Configuration in IIS
What is Team Suite Trial Edition?

Printing by using a vba code

Hi Gents

I would like to get excel to print the lables I have created just by pressing the button.

Now I know how to record macros and get them to work but in this case it is necessary to know some vba code i guess. Say that today I have created 7 lables and I want excel to print those 7 lables by pressing the button......The problem is that the number of lables changes every day....So How could I get excel to recognise the number of lables created and therefore to print them

Thanks in advance

Answer this question

Printing by using a vba code

  • Bertrand JURADO

    It would be easier, if you also have MS Word, to use the mail merge feature in Word to create labels from the data held in Excel. Type in 'mail merge' in Excel help to see what to do.

    hth
  • Printing by using a vba code
Answer this question