How to autohide/unhide Rows
Im very unfamiliar with writing VBA code, or any code for that matter. I currently have a sheet where column B pulls data (names) from another sheet. In column A I have this formula for the corresponding data in column B =IF(B49=" ","Hide","")
I am only working with rows 48-330.
I am trying to write a macro that will hide any row that has the word Hide in column A and will unhide any row that is blank in column A. I have tired writing a few different codes but feel like I am going in circles and not getting anywhere. This is what I know for sure
Private Sub Worksheet_Change(ByVal Target As Range)
End If
End Sub
microsoft-excel-2010 vba macros
asked Jan 23 at 23:34
Lholmey32Lholmey32
62
add a comment |
Im very unfamiliar with writing VBA code, or any code for that matter. I currently have a sheet where column B pulls data (names) from another sheet. In column A I have this formula for the corresponding data in column B =IF(B49=" ","Hide","")
I am only working with rows 48-330.
I am trying to write a macro that will hide any row that has the word Hide in column A and will unhide any row that is blank in column A. I have tired writing a few different codes but feel like I am going in circles and not getting anywhere. This is what I know for sure
Private Sub Worksheet_Change(ByVal Target As Range)
End If
End Sub
microsoft-excel-2010 vba macros
asked Jan 23 at 23:34
Lholmey32Lholmey32
62
1
You can add a filter to the data and filter out theHiderows.
– Scott Craner
Jan 23 at 23:37
1
As this file is shared with hundreds of people every year with my work, most of them would be clueless as to how to use a filter, I want it fool proof so once the macro is embedded the user doesn't have to do any work.
– Lholmey32
Jan 24 at 0:09
add a comment |
Im very unfamiliar with writing VBA code, or any code for that matter. I currently have a sheet where column B pulls data (names) from another sheet. In column A I have this formula for the corresponding data in column B =IF(B49=" ","Hide","")
I am only working with rows 48-330.
I am trying to write a macro that will hide any row that has the word Hide in column A and will unhide any row that is blank in column A. I have tired writing a few different codes but feel like I am going in circles and not getting anywhere. This is what I know for sure
Private Sub Worksheet_Change(ByVal Target As Range)
End If
End Sub
microsoft-excel-2010 vba macros
asked Jan 23 at 23:34
Lholmey32Lholmey32
62
Im very unfamiliar with writing VBA code, or any code for that matter. I currently have a sheet where column B pulls data (names) from another sheet. In column A I have this formula for the corresponding data in column B =IF(B49=" ","Hide","")
I am only working with rows 48-330.
I am trying to write a macro that will hide any row that has the word Hide in column A and will unhide any row that is blank in column A. I have tired writing a few different codes but feel like I am going in circles and not getting anywhere. This is what I know for sure
Private Sub Worksheet_Change(ByVal Target As Range)
End If
End Sub
microsoft-excel-2010 vba macros
microsoft-excel-2010 vba macros
asked Jan 23 at 23:34
Lholmey32Lholmey32
62
asked Jan 23 at 23:34
Lholmey32Lholmey32
62
edited Jan 24 at 0:14
Lholmey32
asked Jan 23 at 23:34
Lholmey32Lholmey32
62
asked Jan 23 at 23:34
Lholmey32Lholmey32
62
asked Jan 23 at 23:34
Lholmey32Lholmey32
62
62
1
You can add a filter to the data and filter out theHiderows.
– Scott Craner
Jan 23 at 23:37
1
As this file is shared with hundreds of people every year with my work, most of them would be clueless as to how to use a filter, I want it fool proof so once the macro is embedded the user doesn't have to do any work.
– Lholmey32
Jan 24 at 0:09
add a comment |
1
You can add a filter to the data and filter out theHiderows.
– Scott Craner
Jan 23 at 23:37
1
As this file is shared with hundreds of people every year with my work, most of them would be clueless as to how to use a filter, I want it fool proof so once the macro is embedded the user doesn't have to do any work.
– Lholmey32
Jan 24 at 0:09
1
1
You can add a filter to the data and filter out the
Hide rows.– Scott Craner
Jan 23 at 23:37
You can add a filter to the data and filter out the
Hide rows.– Scott Craner
Jan 23 at 23:37
1
1
As this file is shared with hundreds of people every year with my work, most of them would be clueless as to how to use a filter, I want it fool proof so once the macro is embedded the user doesn't have to do any work.
– Lholmey32
Jan 24 at 0:09
As this file is shared with hundreds of people every year with my work, most of them would be clueless as to how to use a filter, I want it fool proof so once the macro is embedded the user doesn't have to do any work.
– Lholmey32
Jan 24 at 0:09
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "3"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
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%2fsuperuser.com%2fquestions%2f1397689%2fhow-to-autohide-unhide-rows%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Super User!
- 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%2fsuperuser.com%2fquestions%2f1397689%2fhow-to-autohide-unhide-rows%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
1
You can add a filter to the data and filter out the
Hiderows.– Scott Craner
Jan 23 at 23:37
1
As this file is shared with hundreds of people every year with my work, most of them would be clueless as to how to use a filter, I want it fool proof so once the macro is embedded the user doesn't have to do any work.
– Lholmey32
Jan 24 at 0:09