Hi, i was looking for some help with a macro I have written. What I was looking to find out is if it is possible to have 2 worksheets that are set as WS1.

Currently I have the following:

Set WS1 = ("Sheet1")
but I need the macro to run on 2 sheets i.e.

Set WS1 = ("Sheet1", "Sheet2")
but this gives me an error, any ideas on how i can get this to work?

Thanks in advance.