I am using "Mid" formula to extract the term "Open" into a new cell, sorting by "Open" and want to delete all data that is sorted and that data only. However, running this code I am getting a run time error '424': object required. I simply can't get past, any advice? Below is the code, everything works up to and including the red text, the blue text is where I get my error.
Sorry all, I'm a newbie to the forum and to VBA and just learning both. Apologies for any inaccuracies or omissions in my postings.
Sub OpenShiftDelete()
'
' OpenShiftDelete Macro
'
'
End Sub
Bookmarks