+ Reply to Thread
Results 1 to 10 of 10

Need help on Print # code statement with cell data

  1. #1
    Registered User
    Join Date
    10-12-2011
    Location
    Malaysia
    MS-Off Ver
    Excel 2016
    Posts
    94

    Need help on Print # code statement with cell data

    Hi Guys,

    Goodday. I need your expertise help to amend for below code. How do I include the date (live) & print # data from cell?
    Please Login or Register  to view this content.
    Thank you
    Dean

  2. #2
    Forum Expert Tinbendr's Avatar
    Join Date
    06-26-2012
    Location
    USA
    MS-Off Ver
    Office 2010
    Posts
    2,125

    Re: Need help on Print # code statement with cell data

    E.g.
    Please Login or Register  to view this content.
    David
    (*) Reputation points appreciated.

  3. #3
    Registered User
    Join Date
    10-12-2011
    Location
    Malaysia
    MS-Off Ver
    Excel 2016
    Posts
    94

    Re: Need help on Print # code statement with cell data

    Hi David,

    Noted & Thank you. If I want to set the font size, bold & number of copies to print how would be the code?

    Rgds
    Dean
    Last edited by Dean Zuki; 12-22-2014 at 10:09 PM. Reason: Additional request

  4. #4
    Forum Expert Tinbendr's Avatar
    Join Date
    06-26-2012
    Location
    USA
    MS-Off Ver
    Office 2010
    Posts
    2,125

    Re: Need help on Print # code statement with cell data

    You can't.

  5. #5
    Registered User
    Join Date
    10-12-2011
    Location
    Malaysia
    MS-Off Ver
    Excel 2016
    Posts
    94

    Re: Need help on Print # code statement with cell data

    Dear David, any idea or suggestion for print issue?

    Rgds
    Dean

  6. #6
    Forum Expert Tinbendr's Avatar
    Join Date
    06-26-2012
    Location
    USA
    MS-Off Ver
    Office 2010
    Posts
    2,125

    Re: Need help on Print # code statement with cell data

    Reread the post and realized you are probably printing to a printer.

    You'll have to send the escape codes for your printer for the formatting required.

    You just have to send the codes along with the text.

    Please Login or Register  to view this content.
    Here is a link to Printer Codes.

  7. #7
    Registered User
    Join Date
    10-12-2011
    Location
    Malaysia
    MS-Off Ver
    Excel 2016
    Posts
    94

    Re: Need help on Print # code statement with cell data

    Yes David you are right. I use EPSON printer. Sorry for not mentioned earlier. How to make this printer print copy follow value at cell.

    Thank you
    Dean

  8. #8
    Registered User
    Join Date
    10-12-2011
    Location
    Malaysia
    MS-Off Ver
    Excel 2016
    Posts
    94

    Re: Need help on Print # code statement with cell data

    Dear All,

    Anybody can help me please? Is it possible to use printOut copies function follow value on cell with this print# statement? Any suggestion?

    Thank you
    Dean

  9. #9
    Forum Expert Tinbendr's Avatar
    Join Date
    06-26-2012
    Location
    USA
    MS-Off Ver
    Office 2010
    Posts
    2,125

    Re: Need help on Print # code statement with cell data

    I don't think there is a # of copies in the Epson printer code book, so you'll just have to send the print codes inside a loop.

    Please Login or Register  to view this content.

  10. #10
    Registered User
    Join Date
    10-12-2011
    Location
    Malaysia
    MS-Off Ver
    Excel 2016
    Posts
    94

    Re: Need help on Print # code statement with cell data

    Dear David,

    Noted & thank you. I really appreciated for your kind assistance. Problem solved. Have a good day.

    Regards
    Dean

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Problem with code to print value in data form to a cell
    By RN12345 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-23-2014, 04:26 PM
  2. If cell is active (text in cell) print area (A1:?52) Please see code I think I am Close
    By Jeff up North in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-18-2013, 06:27 PM
  3. Color code cell with case statement and datestamp cell(s) to the left
    By garricko in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-26-2010, 08:37 PM
  4. Print out listbox data code
    By herukuncahyono in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-12-2010, 08:50 PM
  5. How do I code a footer to print variable cell data on each printed page?
    By DeannaT in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-04-2008, 12:14 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1