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?
 

Some videos you may like

Excel Facts

Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.

Watch MrExcel Video

Forum statistics

Threads
1,108,493
Messages
5,523,267
Members
409,506
Latest member
reneekeane

This Week's Hot Topics

Top