Referencing Multiple Worksheets for same command

[ScabbyDog]

I have the following code but want it so that instead of having to type With ThisWorkbook.Worksheets every time that it is just one line as in ThisWorbook.Worksheets("A) and ("B") and ("C") etc etc. It must be simple but I can't get it to work.

Please Login or Register  to view this content.

[uncle_romania]

This might help - http://www.msexcelspreadsheet.com/vi...heets_vba.aspx

[ScabbyDog]

What if the worksheets names aren't in any particular order which mine are not. I was just giving an example above. The names are actually Data1, Output2 and Analysis5

[Norie]

Try this.

Please Login or Register  to view this content.

[ScabbyDog]

I tried that Norie. Got error message "Expected Array" and it highlighted "Ubound"

EDIT: Just saw you edited posted and it works now.

[Norie]

Yes, there were a few typos in there.