Hello,
I am selecting multiple worksheets in a workbook.
While those are selected, I am clicikng on a cell on the active worksheet, say I click on B5.
At this point I want to run a macro which displays in a message box the current values on cell B5 of all selected workseets along with the correspnding worksheet name like:
B5 on Sheet3 is: x
B5 on Sheet6 is: y
B5 on Sheet9 is: z
and so forth..
Could you please advise on such a script?
Thank you
Bookmarks