.
This ?
![]()
Option Explicit Sub findCol() Dim col As String, cfind As Range Dim condition_range As Range col = InputBox("Enter Column Name ...", "Find Column") Set cfind = Cells.Find(what:=col, lookat:=xlWhole) cfind(3).Select Set condition_range = Application.InputBox(Prompt:="Please Select or Enter Range", Type:=8) Range(ActiveCell, condition_range).Select Selection.Delete xlShiftUp End Sub
Bookmarks