Macro Checkbox to hide multiple blank rows

Hello qiyusi,

Welcome to the Forum!

The macro below has been added to the attached workbook. The rectangles have been replaced with Forms Control CheckBoxes and the macro assigned to them.

Please Login or Register  to view this content.

Wonderful! Works perfectly!

Many thanks for your help master. really appreciate it.

wondering to know the language,

1. dim c ---> c refer to what? is it column C? if i insert another two checkbox c change to e?


2. ' CurrentRegion is the cells in the table.
Set Rng = Range("A1").CurrentRegion
if i insert two column to the right, so the range cells begin in C1, then Range("A1") should be change to Range("C1") ?

3. ' Ignore the first 2 rows of the table.
Set Rng = Intersect(Rng, Rng.Offset(2, 0)) --- > if i insert two column to the right as question no.2 should this rng.offset change?

sorry to ask dumb question, i am really beginner at this point.

Hello qiyusi,

Not dumb questions at all.

The variable "c" is a long data type used to hold the column number.

The current region is defined as a range of contiguous (touching) cells. The boundaries are one or more blank rows or columns or the edge of the worksheet.

The First 2 rows are just header data. This does not need to be checked.

Hello qiyusi,

The first cell of range is always the top leftmost cell. In the orinal table this was "A1". Now that you have moved the table by inserting new columns, the starting cell is "C1".

This line needs to be changed...

Please Login or Register  to view this content.

Hello qiyusi,

Okay, I revised the macro so you can move the table around. The check box names are now used to indicate the table column to use.

Before I was using the worksheet column position which is absolute reference. Now, the check box name indicates a relative reference based on the table's columns.

Please Login or Register  to view this content.

Hello qiyusi,,

You're welcome. Glad to help.