hide rows cell value

Hello, I have a table with two columns (min value and max value) and I want to filter the rows typing in the desired range in two separate cells. I have achieved to make it for the first column. It is as follows: Sub SearcRange() 'Hide Dim Cell As Range Var = Range("C1").Value...

I found the following coding but I would like to know to adapt it to text <colgroup><col width="64" style="width: 48pt;" span="8"> <tbody> Private Sub Worksheet_Change(ByVal Target As Range) If Target = "Indeterminate" Or "Term" Or "Transfer" Or "As Required" Then Exit Sub...

Hi All, I have a large budget spreadsheet where i have various codes ranging from A1-A50, however right now I only use about 15 of the codes but the other ones will be eventually populated. The description column uses an index match Formula which looks up a code list. What i want to do is hide...

Hi I used the following code to hide rows based on a cell value: Private Sub Worksheet_Calculate() Dim MyResult As String Application.EnableEvents = False Rows("11:" & Worksheets("Vouchers").UsedRange.Rows.Count).EntireRow.Hidden = False MyResult =...

Okay, this is my first post AND I am not super-familiar with VBA/scripts. I know how to insert codes and that's about it. I work as a legal trainer, and usually am the one showing people how to do stuff. So, if you want to educate me within your response, that's better for me in the long run. If...

Hi, I have the below code to hide rows based on the date in column "C". What I am trying to do is hide rows older than today's date. It's working but not all rows are being hidden. Any suggestion? Thank you in advance. Windows 7, MS 2010. Private Sub Hidebtn_Click() Dim myRg As Range Set...

I am trying to write VBA to hide or unhide a number of rows based on the selection of a dropdown list. I am brand new to VBA and although I was able to piece this together by exploring the internet, it is not working in my worksheet. Honestly, I just copied, pasted and edited this code and I...

I've looked around these forums and done some searching on Google but didn't find exactly what i was looking for so i hope you guys can help me out! Ok, So i have an excel sheet in which i need to do the following: I have a dropdown menu with some 300 values in cell A1 from which users can...

Hi, I have been working on this VBA macro to hide certain rows dependent on whether the drop down list is set to 5 or 6 years (its a loan calculator). Can someone tell me what is wrong? I have put it in the sheet VBA as worksheet_change. If Intersect(Target, Range("I6")) Is Nothing Then...

Hi there, I have the code below that hides rows if the test cell is 0 or blank. The screen on sheet 1, which drives the results for this "Q U O T E" Sheet, was flickering badly when every drop down box or tick box was selected. I Fixed that with "Application.ScreenUpdating = False" However...

http://tinypic.com/r/149xo37/6 Above is a picture of my data set. Hi All, New member here. I am working with in Office 2008 (For Mac). I want to auto-hide some rows when two columns of criteria match. I will provide an example: Since A3 through A6 match, AND C3 through C6 match, I want to hide...

I know there is probably a simple way to do this, but I'm new to VBA. I have multiple drop-down lists and for some I am trying to unhide rows if a specific drop-down item is selected and rehide them if the drop-down item is later changed. For example, if in row 17 "Red" is selected, rows 18 and...

Hi, I have read other posts about this but I am still a little confused as most macros that have been made are tweaked to suite the users individual needs. What I want is something like this to work in the active sheet: If cells D2:D55 = "" Then Hide.EntireRow If cells D2:D55 = "has any...