selecting between worksheets to run codes

[freak11]

I am running this code from a worksheet called recording.xlsb. I want to run further vba codes but in the worksheet openWB. How can I select the openWB sheet so that further codes are being run in the openwb worsheet and not in the recording.xlsb sheet

Please Login or Register  to view this content.

[SamT]

I'm sorry, I don't understand the question.

[Norie]

As far as I can see the code you posted will be run/applied to the workbook that's opened because you fully reference that workbook and a sheet in it.