findrng

I am searching for a string in more than 1 worksheet (in a entire workbook with more than 10 sheets) . For this i am looping through all the worksheets to find the results. Is there any way for me to know , IN HOW MANY SHEETS THE VALUE HAS BEEN FOUND?? Precisely, i want to know whether a value...

I am trying to find the multiple row numbers in which a particular value is found inside. In the code shown below, the red coloured line shows an error Sub LoopThroughSheets() Dim findRng As Range Dim firstRow As Long Dim row As Long Dim allFinds As String Dim numberOfRowsWithSameMKB As...

Sub LoopThroughSheets() Dim findRng As Range Dim firstRow As Long Dim nextRow As Variant Dim allFinds As String Dim numberOfRowsWithSameMKB As Integer Workbooks(SYSDatei).Activate For j = 0 To SizeOfMKB_array - 1 For Each ws In Workbooks(SYSDatei).Worksheets wsName =...

I am using FindNext function to get the row information of cell containing a variable called 'MKB' . my code is given below : Sub LoopThroughSheets(MKB As Variant) Dim findRng As Range Dim firstRow As Long Dim allFinds As String Workbooks(SYSDatei).Activate For j = 0 To...