Avatar of Jens Christian Wulff
Jens Christian Wulff
Flag for Denmark asked on

Display of row depending on values (yes / blank) in cell of row upon opening of sheet

Need a VBA script to run upon opening of sheet giving the user a specifc selecton of rows based on content of one cell in every row.

Thanks for all the expert advice!! BR
Microsoft ExcelMicrosoft Office

Avatar of undefined
Last Comment
Jens Christian Wulff

8/22/2022 - Mon
Roy Cox

Sounds like you need to use AutoFilter. Attach an example workbook to help better understand your requirements.
Jens Christian Wulff

Thanks Roy. Will do ASAP.
Ryan Chong

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Jens Christian Wulff

Thanks Roy & Ryan,

Touch’e - this will work like a charm. I need to dive into the programming manual a lot more. Have a great weekend both.
Best Regards
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck
Log in to continue reading
Log In
Sign up - Free for 7 days
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
Jens Christian Wulff

So it is actually (sry for my lack of insight) possible to build and operate a multidimensional array with different autoformats build into each secondary array! That’s neat!