![]() ![]() We all have different situations and it's impossible to account for every particular need one might have. How Do I Modify This To Fit My Specific Needs?Ĭhances are this post did not give you the exact answer you were looking for. ![]() ![]() SearchFormat:=False, ReplaceFormat:=False LookAt:=xlPart, SearchOrder:=xlByRows, MatchCase:=False, _ What:=myArray(fndList, x), Replacement:=myArray(rplcList, x), _ 'Loop through each worksheet in ActiveWorkbook (skip sheet with table in it)įor Each sht In ActiveWorkbook.Worksheets MyArray = Application.Transpose(TempArray)įor x = LBound(myArray, 1) To UBound(myArray, 2) Set tbl = Worksheets("Sheet1").ListObjects("Table1") 'PURPOSE: Find & Replace a list of text/values throughout entire workbook from a table ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |