Hello,
I'm hoping I can get some help finishing this code
The above code will take the value from A1 (List End) and remove it from column F (the column with the fruit names). However, I need the adjacent cell also removed like the example below.
(Note: I can't simply remove the row because of other data on the sheet.
Thanks for any help with this
I'm hoping I can get some help finishing this code
VBA Code:
Sub Remove_ListEnd()
Dim vSpecificVal As Variant
vSpecificVal = Worksheets("Obv_OI_TI").Range("A1").Value
Call Worksheets("Obv_OI_TI").Range("F1:F1000").Replace(vSpecificVal, "")
End Sub
The above code will take the value from A1 (List End) and remove it from column F (the column with the fruit names). However, I need the adjacent cell also removed like the example below.
(Note: I can't simply remove the row because of other data on the sheet.
Thanks for any help with this