srchrng

Hello, I'm stuck and need help please help me I need the following macro to work across 35 tabs after tab7 Sub FDADATE2() Dim SrchRng As Range, cel As Range Set SrchRng = Range("A:C") For Each cel In SrchRng If InStr(1, cel.Value, "FDA") > 0 Then cel.Offset(0, 2).Value =...

morning, I have a table and I want to delete entire rows, if there is any value in them. I've come this far, by modifying previous code I have, but need some help changing the "void" to search for any number in that field. Sub DeleteShip() Dim c As Range Dim SrchRng Set...

Good afternoon, I am trying to find a certain cell value, and when it finds it, past a static value in the cell next to it. It is an error report, and there are 5 error columns, starting with "Reviewer Error 1 Comment" up to "Reviewer Error 5 Comment", and next to each of those there is...

Hello, I am working on a macro that I was able to configure based off of a macro I found. What I'd like to be able to do ideally, is to have a series of cells that I can enter values into. Say, 20. It would be a table of say, 2 columns and 20 rows on a different sheet, we'll call it sheet two...

I have a code to delete specific rows depending on whether or not the cell value is set to "Void". Sub DeleteRows() Dim c As Range Dim SrchRng Set SrchRng = ActiveSheet.Range("E1", ActiveSheet.Range("E65536").End(xlUp)) Do Set c = SrchRng.Find("Void", LookIn:=xlValues)...

I'm trying to make a spreadsheet that checks all cells in a given range on one sheet and then displays relevant information in a separate form in another sheet. Long story short I got a code to work, but it only looks for the cell value. For this examply I just want it to find "OCC" out of...

Hey Guys, Please check code below. This code will delete entire row if it find the given word. I want to change this code to give more words criteria instead of one word. So that i no need to repeat the code again and again to delete the rows. Thank you. Sub DelWords() Dim SrchRng As Range, Cel...