Warning: session_start() [function.session-start]: Cannot send session cookie - headers already sent by (output started at /home/dbswav/public_html/excelwithkenan.com/goster_hazir_makrolar.php:61) in /home/dbswav/public_html/excelwithkenan.com/header.php on line 2

Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /home/dbswav/public_html/excelwithkenan.com/goster_hazir_makrolar.php:61) in /home/dbswav/public_html/excelwithkenan.com/header.php on line 2

Excel Free Macros (VBA)

---

Hiding External Rows İn Colored Cells

Online Excel and Excel Macro (VBA) Courses

Copy Macro 'For online Excel courses click: https://www.excelsizeyeter.com/excelwithkenan.com/udemy_giris.php Option Explicit Sub macro1() Dim i As Long Dim j As Long Dim sVal Dim bHide As Boolean j = 65000 For i = 1 To j If j 36 Then bHide = True End If If bHide Then Rows(i & ":" & i).Select Range("A" & i).Activate Selection.EntireRow.Hidden = True j = j - 1 End If Next i End Sub

Report problem with this macro

This macro does not work.
There's an error in the code.
Other
You can write your comments about the error in the box below.

Report error

ALL MACROS Youtube Channel
The following macros may be useful for you.

Similar Results

No	Macro Name
1	hiding external rows in colored cells
2	a1: j44 hiding external cells
3	row column hiding
4	hiding row column 1
5	excel operators hk
6	write the number you want to be colored on the sheet / page in msgbox
7	a1: j44 do not show external cells
8	watermark printing (faded font on sheet / page background)
9	hiding row is solved in second click
10	Cells a1 to a3000 make red if there is any data and send the line completely to sheet / page 3
11	hiding formulas
12	collecting / counting colored cells (how many cells in the color I want)
13	hiding line 6 jumping line
14	row column hiding 2
15	gathering multiple names under one name with spending
16	Color the cell according to the words written in it
17	search color
18	specify file path and extension list in detail
19	opens rows on sheet / page
20	Search for a text / text in all open Excel files

---

---

Online Excel Courses

Online Excel Courses are here...

Click to see

Services

• Advanced Excel Courses
• Excel Macro Courses
• Comporate Valuation Courses
• Financial Mathematics
• Financial Modeling
• Comporate Valuation Services

How can we help you?

You can contact us about our services.

Contact us

Subscribe to our Youtube Channel?

Here are the videos that will make your life easier using Excel.

Subscribe Now

Keywords

Excel Videos Advanced Excel Courses Free Macros Free Excel Templates Excel Macro Courses