You need to use a Range in the Intersect method. Pass these parameters, not integers (e.g. Row(s) or Column(s)).
You need to use a Range in the Intersect method. Pass these parameters, not integers (e.g. Row(s) or Column(s)).
Regards, Zack Barresse
Check out the KB! :|: BOARD TAGS: WHAT ARE THEY AND HOW DO I USE THEM
What is a Microsoft MVP? | Free Microsoft Courses | My Book on Excel Tables