Is it possible to write VBA code for XL97 that will search inside the comments attached to a cell in excel for each sheet in the workbook.The number and names of the sheets will constantly be changing.Ideally what I'd like to do is something like:1. Go to first sheet in workbook2. for each sheet in workbook search the comments for desired info3. On finding result return message stating the sheet name and cell that the comment is attached to and the choice to end searching here and go to that cell or continue searching4. On not finding result return message with simple 'OK' button and end the macro.Thanks for any help/pointers in the right direction.
click here should get you started.
This thread is now locked and can not be replied to.
OnePlus 5 review
Alice Saey's mesmerising animation for Dutch singer Mark Lotterman
iPad Pro 10.5in (2017) review
Comment booster votre iPhone ?
© Copyright 2017 IDG UK. All Rights Reserved.