Results 1 to 4 of 4

How to: If field is empty do not print sheet

Threaded View

  1. #1
    Registered User
    Join Date
    06-11-2010
    Location
    The Netherlands
    MS-Off Ver
    Excel 2010
    Posts
    81

    How to: If field is empty do not print sheet

    I have a script running like this:
        Sheets("Data").Select
        Range("A2").Select
        Selection.Copy
        Sheets("Barc").Select
        Range("C1").Select
        ActiveSheet.Paste
        Application.CutCopyMode = False
        ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True
        Sheets("Data").Select
        Range("A3").Select
        Selection.Copy
        Sheets("Barc").Select
        Range("C1").Select
        ActiveSheet.Paste
        Application.CutCopyMode = False
        ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True
        Sheets("Data").Select
        Range("A4").Select
        Selection.Copy
        Sheets("Barc").Select
        Range("C1").Select
        ActiveSheet.Paste
        Application.CutCopyMode = False
        ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True
    and it continues on. But if for instance A4 field in Data is empty I want it not to print out that barcode sheet. But I do want it to continue to the next field to check.

    Does anybody have a idea how I can arrange this in the macro?
    Last edited by dutchmaste; 06-11-2010 at 07:01 AM. Reason: code tags

Thread Information

Users Browsing this Thread

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

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