Working Only With Selected Workbook in a Userlist

[TBrooker]

Hello,

I am struggling to wrap my head around why this doesn't work though it's probably quite obvious.

I have populated a listbox with all open workbooks and selected a workbook from that list. This workbook is then given the name ClassBook, using a msgbox I have confirmed that this works up until here.

Moving forward how do I then work only on that workbook for example deleting rows etc.

Please Login or Register  to view this content.

Rather than only deleting rows on the selected workbook in the userlist the above code simply deletes rows on whichever workbook is open. How do I fix this? Any help would be greatly appreciated.

[Norie]

Put a dot in front of Worksheets.

[TBrooker]

Thank you!

Knew it would be something simple.