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.
Any idea where this might be falling over?
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?