windows(...).activate

[vbacoder]

I'm using the command:

windows("filename").activate

to select an open worksheet, from many that are open. Is there any way of making the worksheet reference in the brackets more generic, so it selects the worksheet that is currently open?

Thanks,

vcoder

 

[VoG]

ActiveSheet.Activate

But why do you need to do this?

 

[vbacoder]

Hi VogII,

Many thanks for your response.

Sorry, I mean workbook not worksheet. I want to select the one that has most recently been open, so that I can automatically carry out operations on it via a macro.

Many thanks,

vcoder