Select Multiple Sheets In A Vb Code

Deci, try using the Macro Recorder, that would have given you the code.

Hi royUK

Using the macro recorder will indeed give you the code, however, it will give you the code using the sheets name. However, as the name may well change you would have to refer to them by number.

Nevertheless using the macro recorder is a great tip that many users forget is available as their experience grows - most of us actually start to learn from the macro recorder.

DominicB

Domenic, I was only pointing out that the Recorder can often give you the basic code needed rather than waiting for a reply on a Forum. Agreed, the code generally needs working on.