VBA Edit Links

[p45cal]

1. What is intersect and what function does it perform in that code?

Step through the following macro with F8 on the keyboard observing the active sheet as you go.

Sub blah3()
Set rngA = Range("B2:F8")
Set rngB = Range("E6:I12")
rngA.Select
rngA.BorderAround 1
rngB.Select
rngB.BorderAround 1
Intersect(rngA, rngB).Select
Intersect(rngA, rngB).Interior.Color = rgbLightGrey
Range("B2").Select
End Sub

2. Can you explain to me how the below copies the sheets and pastes in the exact formats as required into a new workbook?
Sheets(Array("Mainstay Master", "Mainstay Report")).Copy

It's the same as doing the following but record a macro while you: select both the sheets' tabs (use the Shift key to help with that as, you do with cells)
Right-click one of the selected sheet tabs and choose Move or Copy, then in the To book: dropdown field choose (new book), then tick the Create a copy tick box, click OK. Stop recording and examine the code.
Copying sheets copies pretty much everything. By copying both sheets at once it looks like they keep their interrelationship.

What does the array function do?

It puts the two strings (sheet names) into an array in memory and is one way the code wants to see multiple sheets referred to:
2021-03-03_182421.png

How comes you don't need to declare?

Because I don't put Option Explicit at the top of the code-module; lazy.

How do I acknowledge your expertise?

You've already done so merely by replying. I try to remember not to help again when people just run off with a solution without giving any sort of feedback (on some forums it could just be marking the thread as 'Solved').