don't print certain rows and columns
up vote
0
down vote
favorite
I can program my sheet to not print rows C & D in a sheet that includes columns A through H but I also want my sheet to not print rows where the cell in column E has no value. Here's what I'm using to not print rows C & D.
Private Sub Workbook_BeforePrint(Cancel As Boolean)
If ActiveSheet.Name = "Sheet1" Then
Cancel = True
Application.EnableEvents = False
Application.ScreenUpdating = False
With ActiveSheet
.Range("C1,D1").EntireColumn.Hidden = True
.PrintOut
.Range("C1,D1").EntireColumn.Hidden = False
End With
Application.EnableEvents = True
Application.ScreenUpdating = True
End If
End Sub
excel vba
edited Nov 19 at 18:32
Cindy Meister
13.6k102034
asked Nov 19 at 16:28
Jake
1
add a comment |
up vote
0
down vote
favorite
I can program my sheet to not print rows C & D in a sheet that includes columns A through H but I also want my sheet to not print rows where the cell in column E has no value. Here's what I'm using to not print rows C & D.
Private Sub Workbook_BeforePrint(Cancel As Boolean)
If ActiveSheet.Name = "Sheet1" Then
Cancel = True
Application.EnableEvents = False
Application.ScreenUpdating = False
With ActiveSheet
.Range("C1,D1").EntireColumn.Hidden = True
.PrintOut
.Range("C1,D1").EntireColumn.Hidden = False
End With
Application.EnableEvents = True
Application.ScreenUpdating = True
End If
End Sub
excel vba
edited Nov 19 at 18:32
Cindy Meister
13.6k102034
asked Nov 19 at 16:28
Jake
1
2
Filter column E by blank values first - you can find plenty ofHow To'son filtering by blanks here!
– urdearboy
Nov 19 at 16:33
add a comment |
up vote
0
down vote
favorite
up vote
0
down vote
favorite
I can program my sheet to not print rows C & D in a sheet that includes columns A through H but I also want my sheet to not print rows where the cell in column E has no value. Here's what I'm using to not print rows C & D.
Private Sub Workbook_BeforePrint(Cancel As Boolean)
If ActiveSheet.Name = "Sheet1" Then
Cancel = True
Application.EnableEvents = False
Application.ScreenUpdating = False
With ActiveSheet
.Range("C1,D1").EntireColumn.Hidden = True
.PrintOut
.Range("C1,D1").EntireColumn.Hidden = False
End With
Application.EnableEvents = True
Application.ScreenUpdating = True
End If
End Sub
excel vba
edited Nov 19 at 18:32
Cindy Meister
13.6k102034
asked Nov 19 at 16:28
Jake
1
I can program my sheet to not print rows C & D in a sheet that includes columns A through H but I also want my sheet to not print rows where the cell in column E has no value. Here's what I'm using to not print rows C & D.
Private Sub Workbook_BeforePrint(Cancel As Boolean)
If ActiveSheet.Name = "Sheet1" Then
Cancel = True
Application.EnableEvents = False
Application.ScreenUpdating = False
With ActiveSheet
.Range("C1,D1").EntireColumn.Hidden = True
.PrintOut
.Range("C1,D1").EntireColumn.Hidden = False
End With
Application.EnableEvents = True
Application.ScreenUpdating = True
End If
End Sub
excel vba
excel vba
edited Nov 19 at 18:32
Cindy Meister
13.6k102034
asked Nov 19 at 16:28
Jake
1
edited Nov 19 at 18:32
Cindy Meister
13.6k102034
asked Nov 19 at 16:28
Jake
1
edited Nov 19 at 18:32
Cindy Meister
13.6k102034
edited Nov 19 at 18:32
Cindy Meister
13.6k102034
edited Nov 19 at 18:32
Cindy Meister
13.6k102034
13.6k102034
asked Nov 19 at 16:28
Jake
1
asked Nov 19 at 16:28
Jake
1
asked Nov 19 at 16:28
Jake
1
1
2
Filter column E by blank values first - you can find plenty ofHow To'son filtering by blanks here!
– urdearboy
Nov 19 at 16:33
add a comment |
2
Filter column E by blank values first - you can find plenty ofHow To'son filtering by blanks here!
– urdearboy
Nov 19 at 16:33
2
2
Filter column E by blank values first - you can find plenty of
How To's on filtering by blanks here!– urdearboy
Nov 19 at 16:33
Filter column E by blank values first - you can find plenty of
How To's on filtering by blanks here!– urdearboy
Nov 19 at 16:33
add a comment |
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53378919%2fdont-print-certain-rows-and-columns%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
2
Filter column E by blank values first - you can find plenty of
How To'son filtering by blanks here!– urdearboy
Nov 19 at 16:33