Sheets(Array("Sheet2", "Sheet3", "Sheet1")).Select - is

[stevebausch]

Found it in a recorded macro; hold down Control, select the sheets.
From that point, what ever you enter in a cell is echoed to that cell location on the other sheets.

I find it quite clever, but I hate to use anything without understanding it.

Is it safe to say that the Wizards understand this line of code forwards and backwards?

Could you help us ordinary folk?

What is going on in this line of code? What's the easy way of referring to this technique?
Are there any possible problems with it?

Thanks,
Steve

 

[PivotMeThis]

Re: Sheets(Array("Sheet2", "Sheet3", "Sheet1")).Select - is

Wow you're the best!!!
Thanks!