Quick questions:
In A2, I have a dropdown for "Y" or "N". If A2 is "N" I would like B1:G1 to be blank to include the ICON. Is this possible?
Quick questions:
In A2, I have a dropdown for "Y" or "N". If A2 is "N" I would like B1:G1 to be blank to include the ICON. Is this possible?
B1:G1? these are headers?
I assume that you mean if A2 = N then B2:G2 goes to blank and A3 --> B3:G3....Am I right?
Happy with my answer * Add Reputation.
If You are happy with solution, please use Thread tools and mark thread as SOLVED.
Oooops! Yes, you are correct..apologies
What happens to B2:G2 if you change A2 from "N" back to "Y"?
I am not sure about column F/G because you've got formulas in there (so check below under VBA code)
Try put it into Sheet code:
and put:Please Login or Register to view this content.
into F2:
Formula:Please Login or Register to view this content.
and into G2:
Formula:Please Login or Register to view this content.
of course drag both down and long as needed.
Thank you for helping...im sorry, but I am fairly new to excel...how do I input the first code/formula you mentioned?
Please Login or Register to view this content.
Last edited by jeffreybrown; 04-17-2019 at 07:04 PM. Reason: Fixed code tags!
When you in excel, press Alt+F11, it will open VBA editor.
Double click on Sheet1 in tree of your workbook on left side of window, and paste it there.
Przechwytywanie11111.JPG
Last edited by KOKOSEK; 04-17-2019 at 07:23 PM.
@KOKOSEC: Your attachment in the prior post is not accessible. I noticed a thread earlier today where other complain of the same issue. https://www.excelforum.com/suggestio...ttachment.html
I have experienced it too. Deleting the attachment and trying again usually works for me.
@Mr Ray: to run KOKOSEC's code make sure that you have macros enabled. Ribbon > Developer > Macro security. If you don't see the developer tab click on the File menu and then select Options from the drop down menu. When the Excel Options window appears, click on the Customize Ribbon option on the left. Click on the Developer checkbox under the list of Main Tabs on the right. Then click on the OK button.
I would like to insert picture, I don't know why it goes as attachment.
p.s. KOKOSEK if you don't mind.
Yeah, there was no definitive answer in the thread I referenced.
Sorry about the typo with your name.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks