unhide

Hi guys. As the title says. I am looking to unhide columns so that I can search them for a value. The cells matching the criteria are then copied and pasted onto sheet two. I have the copy and past working fine. After pasting these columns all need to be hid again. So the part I need help with...

I am working on an analysis spreadsheet which allows for multiple properties to be analysed or for a single property to be analysed and as part of this I have several areas where there is the option to open up additional columns for properties if needed by the user. I have a macro to unhide...

Dear Sir Using following code; Sub Macro1() ' ' Macro1 Macro ' ' Range("A7:A8").Select Selection.EntireRow.Hidden = False End Sub It is linked with button, when I click it, its Unhide the rows A7:A8 I need to write the code then when we click again, it should hide A10:A11 then when...

Hello, 1st time poster Excel level NOOB So I have a workbook and on page 1 of the workbook A22 through A40=A22 through A40 of page 2. A22 through A40 on both page 1 and 2 are formatted as general. The idea here is that I need the data on page 1 to reflect the data on page 2 however on page 2 I...

Hi All I have a 13 hidden sheets in my workbook, Based on the users input the correct sheet to unhide shows in sheet6 cell E10 ie (Upload A or Upload B etc). My question is using VBA how can I make clicking a button unhide the correct sheet? Any help is much appreciated! Thanks Tom

Hi, I saw this formula =VLOOKUP('1 Project Info & Instructions'!$G$25,'Excel Functions'!$D$4:$E$7,2,FALSE) in a sheet that was given to me and i am trying to figure out where is this "Excel Functions" sheet. I unhide all sheets , until the unhide sheet is grayed out. however I see it in VB...

Hi there, I am trying to write a code which hides/unhides rows depending on whether Yes or No is selected. The first part of my code works fine however, I am having trouble with the second part. How do I unhide two ranges of rows? I would prefer not to write two lines of code because it causes...

Hi I want to put a button on the ribbon that will hide and unhide column. I don’t need a password. I want it to toggle each time I click on it First click>>unhide second click>>hide Sub unhide() Columns("a:a").EntireColumn.Select Selection.EntireColumn.Hidden = False End Sub...

Hi. I have a macro to Password protect and hide sheets but cannot get one to unlock and unhide them to work. I am using the code below to lock the workbook and hide the sheets Sub Lock1() Sheets("2018").Select ActiveWindow.SelectedSheets.Visible=False Sheets("Comments").Select...

Hi Guys, I have similar question and I was hoping someone can help me with it as I am trying to develop my VBA capabilities. I have an excel file that will hide and unhide based on multiple values which mainly year and month criteria, meaning: if it is 2016 chosen then all the columns of 2016...

hello! Need your help in this: I need to click a button, and once clicked tell me to search a name in row 2. After clicking yes, the columns that doesn't contain this text will be hidden. and the columns that will contain it (or a part of it) will be shown. Thank you

Greetings, I am working on a spreadsheet for risk assessment entries, the spreadsheet will have specified areas for up to 20 hazards with 12 risks for each hazard. I will need specified rows to hide or unhide based on the numeric value of a cell in column A. i have received excellent help and...

Hello, I have a workbook that consists of 12 sheets for 12 months (eg. January, February, March, etc) I want a text box asking the end-user to enter a specific month's name and thus taking the user to that sheet while making that sheet active. But that's not all, some sheets with the month's...

Hi, I am completing a survey on excel in which I ask a number of questions. I would like to unhide and leave rows hidden based on User selecting Yes or No If No is selected from dropdown list (Yes or No Can be Selected) in row 13 it leaves row 14 to 24 hidden, but if Yes is Selected it will...

Hello, I am working on an excel spreadsheet that i would like to automatically unhide the row below if text is entered in the previous row (specific cell). i have up to 12 rows max that i need to unhide when there is a value in the previous row (specified cell). they would unhide as text is...

Hi, I am very new to VBA, so please be gentle. I am looking for some code that will unhide a specified number of rows, dependant on a Cell value. For Example, If "B2" states 2, then 2 rows will become unhidden, starting from row 2 inclusive (2:3). If "B2" states 5, then 5 rows will become...

Hi I have a master sheet where cells E6 to E20 have either got the word 'HIDE' or 'UNHIDE' in them. Cells D6 to D20 have the names of each of the other 15 sheets in the workbook. The 'HIDE' and 'UNHIDE' cells are displayed based on IF formulas i.e. =IF(E2=1,"HIDE","UNHIDE") If possible, I'd...

Hi, how to Hide or unhide specific rows by inputting Y = Yes to Hide N = No to unhide. like in excel sheet if in B5 input is "Y" it hide row 18 to row 25 and when i input "N" it unhide those rows. does it need to use VBA or it can be done without VBA? thanks and regards, Abhisekh

Hello I really need help with Excel vbd formula. I have listed number of dates in a colum I1 ranging from 2018-04 to 2020/10 the dates that yet not occurred will be hidden but I need a macro that would unhide one month form today date

Hi, May i get help on VBA script to hide and unhide the rows if the formula result is "" in Summary worksheet from Range cell B17:B240. So by pressing the button it should hide the blank rows with unhide if the cell value range from B17:B240 not equal to "".