Hello,
I am a beginner user of VBA and am having trouble finding a function to do what I need. I have a predefined range in excel (about 1000 cells) called Range 1. In this range I have the values "user" and "visitor". When a checkbox (chk1) is checked, I want a code to search Range 1 for the text value "user" and hide the rows between it and "visitor". I do not want user and visitor to be hidden though. Any help is GREATLY appreciated
!
I am a beginner user of VBA and am having trouble finding a function to do what I need. I have a predefined range in excel (about 1000 cells) called Range 1. In this range I have the values "user" and "visitor". When a checkbox (chk1) is checked, I want a code to search Range 1 for the text value "user" and hide the rows between it and "visitor". I do not want user and visitor to be hidden though. Any help is GREATLY appreciated
