Forum Discussion

mzeller1776's avatar
mzeller1776
Brass Contributor
Apr 15, 2025
Solved

Using multiple ranges

I have an Excel workbook that is used as a form. Depending how the user answers questions or clicks on checkboxes, it is setup to hide or unhide rows. The form is about 250 rows long. It contains mul...
Macros and VBA
  • HansVogelaar's avatar
    HansVogelaar
    Apr 15, 2025

    Select rows 159:162.

    Click in the name/address box on the left-hand side of the formula bar.

    Type CVVINFO and press Enter.

    Select C157.

    Click in the name/address box on the left-hand side of the formula bar.

    Type CVVINFO_Cell and press Enter.

    Select rows 99:105.

    Click in the name/address box on the left-hand side of the formula bar.

    Type BINBalInfo and press Enter.

    Select C97.

    Click in the name/address box on the left-hand side of the formula bar.

    Type BINBalInfo_Cell and press Enter.

    In the code, replace:

    159:162 with CVVINFO
    C157 with CVVINFO_Cell

    99:105 with BINBalInfo
    C97 with BINBalInfo_Cell

     

HansVogelaar's avatar
HansVogelaar
MVP
Apr 15, 2025

Select rows 159:162.

Click in the name/address box on the left-hand side of the formula bar.

Type CVVINFO and press Enter.

Select C157.

Click in the name/address box on the left-hand side of the formula bar.

Type CVVINFO_Cell and press Enter.

Select rows 99:105.

Click in the name/address box on the left-hand side of the formula bar.

Type BINBalInfo and press Enter.

Select C97.

Click in the name/address box on the left-hand side of the formula bar.

Type BINBalInfo_Cell and press Enter.

In the code, replace:

159:162 with CVVINFO
C157 with CVVINFO_Cell

99:105 with BINBalInfo
C97 with BINBalInfo_Cell

 

Resources