Need help tweaking macro

Originally Posted by mehmetcik

Sub DeleteB()
DeleteBlankRows(2)
End Sub

Sub DeleteC()
DeleteBlankRows(3)
End Sub

Sub DeleteBlankRows(t as Integer)
Dim i As Long
Dim Blanks, count,  t as integer
For i = 4 To 26

Blanks =0
For Count = t to t + 12 step 2
If cells(i,t)="" then Blanks = Blanks +1
Next

if Blanks = 7 then
Rows(i).EntireRow.Hidden = True
Else
Rows(i).EntireRow.Hidden = False
End If

Next i
End Sub

Thanks so much for your hasty reply. Can you clarify how I differentiate the 2 macros? am I supposed to plug in values into the third macro you provided? I'm so sorry, I'm a newbie to VBA and need to be hand-held

Thanks again!

I suppose you would want to connect a button or a hot key to the first two macros.

Also some administrative stuff...

please use the code tags when entering code. (select the text and press the # above where you type)

And give the thread a meaningful title - almost everyone who posts a thread here needs help tweaking a macro so it is a very bad term for people to search whether they are trying to help you or to benefit from any insights that might come from the discussion.

I also suggest you don't call hiding rows "deleting rows" - it is unnecessarily confusing if you go back to it at a later stage.

Thank you @mehmetcik! Do I need to create three separate macros then? 2 short macros and 1 main macro? Or do I just create 2? Sorry as I said I am very much a newbie. Need to read VBA for dummies

I mean in the Visual Basic window where you paste code? Do I have to paste each code in a separate window?

Thanks! I tried running this but I am getting an error:

Capture.JPG

Could you possibly edit the code?

Thanks so much again for all your help it is much appreciated!

Thanks Trebor76 and mehmetcik. Replacing the line of code fixed the error, but I just realized it is hiding more than I need it to. Rather than hide the row if there are 7 blanks total, I need to hide the rows only in which all 7 of the every-other-rows are blank, if that makes sense. For example, if the first 7 columns from B-H are blank, the macro should not hide this row because it was not every other row that was blank. It should only hide the row if all columns B,D,F,H,J,L,N are blank OR all columns C,E,G,I,K,M, O are blank. I hope this makes sense, please provide code if possible, thanks so much again for your help.

I posted the code as dictated by forum rules, thanks!