copy, erase & delete multiple sheets woes

  • So I have this code and it does not seem to be working and I have been slamming my head into a brick wall the past 2 days over it. The point of this macro is

    1. find a row on 'Projects' and erase data in cells only. Based on a cell value.
    2. find that same row in other sheets based on cell value & delete that row entirely
    3. Copy the row to a sheet called 'tracking'

    When I attempt to run this macro is says "We could do this for the selected range of cells. Select a single cell and try again" and highlights here

    ws.UsedRange.AutoFilter Field:=1, Criteria1:=N

    I have been trying to figure this out but I cannot seem to find the issue. It should be searching the usedrange? This is my first attempt to use auto-filter like this so it is probably any easy mistake... Any help would be greatly appreciated.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!