Good day gang.
have a vbs script that works well. In my case it parses over 240 worksheets in the workbook and displays on my search sheet based on the target.address
I have it only looping first 8 columns looking for a specific value, number or word, or partial.
If my specific searched word shows up in any column it grabs the whole row, prints to search sheet (this is a sheet code) not a macro.
My issue is,,,, if there is nothing in column "A" even if the target is met in one of the other column loops, it does NOT print the row.
I cannot figure out how to still print row if nothing is in "A", and i am running out of non dented space on desk from my head. Works fine if any other column is empty, it just prints the row.
Thoughs?
Bookmarks