VB scripting

Hi all,

I have a vb script setup, to work on current active cell (in that if you double click, it will collate information from another worksheet and display it in a table) in a particular worksheet. In the spreadsheet, I have 9 worksheets, I want to be able to deploy this active cell in the same way on another sheet, I dont know how to do it.

Any help would be appreciated.

Thanks in advance

No need - I've just worked it out.