How do I find text among multiple worksheets and return the cell .
in [Programming]
|
From: Marc''s NYK on 8 Mar 2010 16:29 Lets say i want to find the text cat in all sheets in my workbook and have the cell address returned to a cell(s) next to it? I want it to look something like this: sheet1 sheet2 sheet3 cat Sheet2!C4 Sheet3!C4 Or even better i would love to write a macro that will search the entire workbook for any text that I put in cell A1. and return all cell addresses for that text. Is this possible?
|
Pages: 1 Prev: error handling in VBA Next: Copy/Paste charts , ranges in PowerPoint |