cellsrowcnt

First of all, good morning and thanks to all of you who come on here and help us out and never asking much in return. You've inspired me to go to other forums where I actually do something about the subject and help out. :) I seem to have a sick dog now that is wanting attention so I've broken...

My macro hides all rows that have the number 3 in the first column. I would like to make it so that it hides rows that have 3,4 or 5. How would I do that here? Sub HideMaddie() BeginRow = 4 EndRow = 141 ChkCol = 1 For RowCnt =BeginRow To EndRow IfCells(RowCnt...

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...

Hey all I have some code that hides rows if a value in a column is = "TERMDT" which works great... But I am trying to get some working that has a few criteria What they asked for is "IF column Z (new status) is W, hide/remove UNLESS column D (BDCA code) is MMJ, MBJ, MNN, MBN, MML, MMP " The...

Hello, need advice with the following Quantity is at column 2 and supplier is at column 3. If the quanity is zero do not send the email at that specific supplier I attach the code Application.ScreenUpdating = False Sheets("ORDERS").Select Columns.EntireColumn.Hidden = False...

So I have two worksheets (Sheet1 and Sheet2). I need to hide the row if the value in column2 = 0. I have found the code to hide the rows (see below), but the code takes forever to run (since it checks every row) and I have to run the code from each Sheet1 and Sheet2. Is there a way I can stay on...

Hi everyone, I am fairly new to VBA, although, after searching Google dry, I really shouldn't be... I have spent far too many days trying to get this working. The Show All and Hide All buttons are only for testing purposes. By default, all rows should show. Starting at row 5, if you click...

Hi All, Hope you may be able to help on the below: I want to make it easier for users to filter the information for what they need using some macro buttons (some struggle with using basic filters); however, it is on a protected and shared workbook so I can't use a VBA filter. I've created...

Hi All. I'm pretty much a novice - this seems like it should be easy but haven't been able to figure it out... Here's what I'm working on - it hides rows based on value of column 3 Sub HURowsMaterialOrder() BeginRow = 2 EndRow = 101 ChkCol = 3 For RowCnt = BeginRow To EndRow...

Hi to all. I am using a VBA code to hide all the lines that have 0 value in column 2. The trick is to run this VBA code when someone wants to print the worksheet. Would like to do this automatically so the code runs before worksheet is being printed instead of running VBA code manually and then...

Hi All I have this bit of code Sub HideOut() Sheets("RDC_OB").Select BeginRow = 208 EndRow = 244 ChkCol = 10 For RowCnt = BeginRow To EndRow If Cells(RowCnt, ChkCol).Value = 0 Then Cells(RowCnt, ChkCol).EntireRow.Hidden = True Else...

Any ideas why autocalc will not switch to auto? Thanks Sub HideRows()With Application ScreenUpdating = False Calculation = xlCalculationManual DisplayAlerts = False EnableEvents = False End With BeginRow = 2 EndRow = 1050 ChkCol = 20 For RowCnt =...