Welcome!

By registering with us, you'll be able to discuss, share and private message with other members of our community.

SignUp Now!
  • Guest, before posting your code please take these rules into consideration:
    • It is required to use our BBCode feature to display your code. While within the editor click < / > or >_ and place your code within the BB Code prompt. This helps others with finding a solution by making it easier to read and easier to copy.
    • You can also use markdown to share your code. When using markdown your code will be automatically converted to BBCode. For help with markdown check out the markdown guide.
    • Don't share a wall of code. All we want is the problem area, the code related to your issue.


    To learn more about how to use our BBCode feature, please click here.

    Thank you, Code Forum.

C++ Automatic printing info

Mischa123.

New Coder
I'm trying to create a code in Microsoft Visual Basic where I can automatically select a certain part of a document. In this case I only want to print the rows where A is not 0. There for my code has to only select the rows, where A is not 0. In my code I print everything and I don't know how to change it, so it only prints the rows that are filled with information.

Can somebody help me?

Sheets("Print").Select
Range("F2").Select
Range("A1:C3").Select
Selection.PrintOut Copies:=1, Collate:=True
End Sub

piet51 weiße 1 Körner 3 Roggen
0​
0
0​
0
 
This does not belong in the C++ forum. As there's no specific forum for VB I guess this should have been posted in the Other Back-End Server Languages forum.
I've gone rather rusty in stuff like this but you'll need to loop through your second range and select rows one by one based on the criterion, rather than selecting the entire range. I think you'll find examples of that if you Google around a bit.
 

New Threads

Latest posts

Buy us a coffee!

Back
Top Bottom