Selecting multiple named ranges and hiding/unhiding associated rows

jonnynacker

New Member
Joined
Sep 11, 2014
Messages
46
Hey Guys,
Been looking everywhere and trying various methods but still get "compile error: wrong number of arguments or invalid property assignment" for my code of selecting multiple named ranges then unhiding rows if hidden.
Code:
Dim Concept_row_headings As range
Set Concept_row_headings = Union(range("basis_of_design"), range("consistent_with_strategic_direction"), range("high_level_func_spec_operating_criteria"), range("swot_or_bbra"), range("basis_financial_evaluation"), range("design_layout"), range("alternatives"), range("capital_allocation"), range("high_timing_schedule_project_timeline"), range("concept_fwp"), range("concept_approval_gate_gap_analysis"))
Concept_row_headings.EntireRow.Hidden = False

Any idea where this might be falling over?
 

Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.

Forum statistics

Threads
1,215,831
Messages
6,127,147
Members
449,364
Latest member
AlienSx

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top