I've been trying to record a macro that will search a column (Col B in my case) for any cells containing the word "day", select these cells and delete them (shift cells to the left).
Whenever I try and record this action it's only recording the cell selection, not the find and select and delete/shift.
Any ideas or solutions?
Bookmarks