Results 1 to 3 of 3

Thread: print filled data of invoice with ignore the empty cells
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    May 2019
    Posts
    60
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default print filled data of invoice with ignore the empty cells

    hi, every one i have data in sheet1 begins from a2: f38 the empty data begins from a17:a32 i just would code print the filled data and ignore the empty data if a17:a32=""

  2. #2
    Board Regular Toadstool's Avatar
    Join Date
    Mar 2018
    Posts
    225
    Post Thanks / Like
    Mentioned
    9 Post(s)
    Tagged
    2 Thread(s)

    Default Re: print filled data of invoice with ignore the empty cells

    If you Hide rows a17:a32 it will print the rows before and after.
    Life advice found on a book of matches: "Keep cool. Keep away from children."

  3. #3
    Board Regular
    Join Date
    May 2019
    Posts
    60
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: print filled data of invoice with ignore the empty cells

    Quote Originally Posted by Toadstool View Post
    If you Hide rows a17:a32 it will print the rows before and after.

    thanks for your replaying but i need code automatically delete the rows empty becuase sometimes a17,a18 ,etc are filling it depends on how many brands in invoice then delete the rest empty rows

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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