Help with CASE statement

Folks,
Admittedly, I am very POOR at CASE statements. In the example below here's my objective.

When the workbook change event is triggered I would like to evaluate which cell generated the change. In the view below cells O6:O9 a function is entered in each cell independently. I have cells Q6:R9 formatted as ";;;".  When a function, for example, in cell O6 has been enter I would like to change the formatting for range Q6:R6 set to "General". The same would apply for O7, O8 and O9 and their corresponding ranges Q7:R7, Q8:R8, and Q9:R9. Would a Case statement be the best way to handle this and what would be the code, please.
 Case statement
Frank FreeseAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Martin LissOlder than dirtCommented:
ActiveCell.Address will give you the cell address.
0
Martin LissOlder than dirtCommented:
What happens if you format them as General before anything is entered?
0
Martin LissOlder than dirtCommented:
Sorry. You need to use Target.Address rather than ActiveCell.Address. And you meant Worksheet_Change, right?
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Frank FreeseAuthor Commented:
When the worksheet is activated range Q6:R9 is formatted as ";;;" I want to keep what's in that range but not visible to the user until a function has been entered.
I did mean worksheet, not workbook.
Target.Address  - I'm looking into that now
0
Martin LissOlder than dirtCommented:
There's nothing wrong with that but what is the purpose?
0
Frank FreeseAuthor Commented:
My fault again - not enough detail.
Every time a function is entered O6:O9 the values in Q6:R9 (that contain formulas) changes.
If I don't ";;;" here's what they would see:
formulasand that's why I hide them when the worksheet is activated or the user elects to Try Again.
The number of cakes and kth percentile can be changed by the user when the Try Again. Every time they enter a function O6:O9 then the format would be "General" and the results would be different.
0
Martin LissOlder than dirtCommented:
I'm not sure I understand. Why can't O6:O9 be blank and instead of having formulas there, do the calculation in the Change event.
0
Frank FreeseAuthor Commented:
OK - got it to work w/o Case but If instead using Target.Address that you suggested
0
Frank FreeseAuthor Commented:
thank you sir - I appreciate you pointing me in the right direction!
0
Martin LissOlder than dirtCommented:
YW
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.