hide

Hi, I am new to VBA coding and i am still in the learning process. Can anybody help me why the codes in red below are not working. I have different sheets in the excel and i have to hide 2 specific row in one sheet when an option is being selected: Sub bar() Dim sht Dim str As String sht =...

Can anyone come up with formula that hides certain rows based on a column value?

Can anyone give me advice on where to get help for hiding rows based on what user you are. I have a userform where users will register and then login to access a certain sheet. Once they register it will place them in a certain row alphabetically so when they login I would like to hide all...

Hide Month Calender Date Column | Excel | VBA I have a Leave Tracker Excel where i want to Hide the Remaining Date Columns for Particular Months Which as Only 28 days or 30 days For example Example 1 : Assume i have Month => FEB YEAR 2019 => It as only 28 Days so remaining Days [29,30,31] Column...

Hi, When I try and right click on the field buttons to hide them there is no menu. Everything else seems to be working fine, any ideas what's happening? Much thanks

Hi Everyone, I have a ist of columns with dates in row 20 full range is "AB20:DXX20" All i want to do is have a macro that when i run it Hide all dates before todays month so right now its 11 may so everying before 1st may please help if you can Thanks Tony

I have a spread sheet with several formulas when the formula is not being used the cell displays #value ... how can i hide this till a value is added?

Hi looking for help with following macros; Sub HURows() BeginRow = 1 EndRow = 100 ChkCol = 3 For RowCnt = BeginRow To EndRow If Cells(RowCnt, ChkCol).Value < 5 Then Cells(RowCnt, ChkCol).EntireRow.Hidden = True Else Cells(RowCnt...

Is there a way in Excel to have a field where you type in a number of rows desired in a field, with a maximum of say 200, and those rows exist with formulas, but all but the number of desired rows will be hidden? Like if I choose 30, rows 31-200 would hide. I don't want a VBA, macro, or a...

hi all I haven't found anything yet that can help me do what i need. Hoping someone may have the answer. I have B11 setup with a drop down list of peoples names. In range D11:IS11 are those same names. i would like a macro that searches D11:IS11 for the name in B11 and if it is found, hide...

Hi Everyone, Ok so I need a macro that will hide all the rows that are blank in this range "S10:BXJ5000" but only visable cells, i.e. some columns are hidden but might contain data but if all visible cells are mpty hide row I've trided doing this but the size is making everything very slow...

Hello, i have a table which contains a column for years from 2014 - 2016,showing only year no month no date and cells format is General . I need a formula to hide the rows containing year in future ( 2020 till 2026 ) when its year 2020 that row should be unhidden and so on. Thanks in advance.

I have drop down lists in 3 cells, C3, C4, and C5 each has 1-4 to pick from. I have the descriptions in row 7:66. If 1 is chosen in C3, I want to hide 10:66, if 1 is chosen in C4 I want to show row 10 and hide 11:66 (if 2 is selected hide 12:66, 3 - 13:66, 4 - 14:66). Lastly if 1 is selected...

Hi all, i've found this macro that will hide columns in a range based on a cell value. But how would the code be written to hide every OTHER column that doesn't contain that value in the row? so as example, if i want to hide every other column EXCEPT the ones with X Sub...

can someone please assist me with creating a macro that will hide all rows that have nothing in column D. if the cell in column D is blank then I would like it hidden

Hi, We can Show or Hide a comment using the Excel Menu. Suppose I select a range on my Excel sheet. Say, there are 5 comments in that range: 4 of them are visible (Show comments) and 1 is hidden (Hide comments). How can we write a VBA macro that will count the number of visible comments, and...

In my workbook, I hide some worksheets and save the file, when I reopen the workbook all hide sheet unhide itself. I am using Excel 2019. Thanks in advance

Hey i have this code that i use to sort my worksheet however i want to include a special provision where if the text in the Range of column "C" equals "TOTAL" do not hide the empty row under it. For example i want the worksheet to have a row separating my tables after the, text TOTAL. Right...

Hello All, I am just beginning to learn about VBA and I have a file I am beginning to workon. Is there a specific reason to use a check box vs a button to hide or unhiderows? While on the subject what are the limitations to each object? Can someone show me a simple macro that will hide...

I wonder if anybody can tell me if this is possible I have a workbook with a few blank sheets; these are used to embed pdf documents if required. However I would like to is run some code to hide the empty sheets if there has not been a pdf document embedded within that sheet. Below code will...