rowcnt

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

this is from the macro that i am using for optimization. need help because when i start the macro it would count 1, 2, 3, 4, 5, 6, 7, 8, 9, 11, 12 and so on. i cannot find out how number 10 is not showing, thanks for the help. *macro 'Stampanje oznake sipke npr.A, B, C...itd. slova =...

Hello Everyone, Question for you. I have been using the following code to hide rows based on a cell value. The macro has worked wonderfully, but today it crashes. Any thoughts would be much appreciated! Sub Hide_All_Rows() Dim sht As Worksheet Application.ScreenUpdating = False For Each sht In...

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