mycell.offset

Trying to figure out why my VLOOKUP won't work in my IF statement, highlighted in RED Set mycell = myworksheet.Range("AK" & i) 'Contains Unit of Measure Set mycell2 = myworksheet.Range("AD" & i) 'Contains UN/ID# Set mycell3 = myworksheet.Range("B" & i) 'Contains static part # If...

Sub Request2() 'THIS SUB: finds NONHAZ, UN2911, or UN3316 and if found populates No Action, No Error, or Compliant in columns AX:AZ ActiveWorkbook.Sheets("HazShipper").Select Application.ScreenUpdating = False Application.DisplayAlerts = False Dim mycell As Range Dim mycell2 As Range Dim...

I'm at the end of my long process of VBA learning/Macro building. I am organizing the way my Macros work and in attempt at changing the look, layout and operation I've decided it would be best to have all my Macros stay in a locked workbook, but all my results return on a brand new workbook. I...

Someone please, for the love of God, tell me what my code is missing so I can move on. I keep getting the "NEXT WITHOUT FOR error, and it won't run my macro. I know this has to be a simple fix, but I've been up since 5am... my brain is too fried to look up anymore answers. Thanks Excel Giants...

I am trying to account for non-numeric values at the end of my string. I input MSP just to test if the code would work with my data set. THE PROBLEM: "MSP" can be any combination of letters and I need to account for all variations. The part of the code in PURPLE has no effect on the data...